Problem with F03B11Z1. CCSID ?

reivilo78

reivilo78

Well Known Member
I have a problem with P03B11Z1.
When we try to open the details of a record that we just added successfully using P03B11Z1, it shows an error, some fields are blank but in the databse theyre not blank, etc...

When looking at JAS.log we see the following message :

[ QUOTE ]

17 juin 2009 17:37:55,753 [Line ?] [SEVERE] OVIDAL - [JAS] JDBCProxy.jdbcProxy(): JDBj database operation failed | UserName : OVIDAL, Environment : JPY812, User Role : *ALL com.jdedwards.database.base.JDBException: [FIELD_VALIDATION_FAILED] Logical Field DI# specified by user does not exist in database Business Data - CRP within table F03B11Z1
com.jdedwards.database.base.JDBException: [FIELD_VALIDATION_FAILED] Logical Field DI# specified by user does not exist in database Business Data - CRP within table F03B11Z1


[/ QUOTE ]

It clearly shows an error on field DI#, it cannot find it in physical database.
After activating the jasdebug.log we see a confirmation :

[ QUOTE ]



17 juin 2009 17:37:55,682 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Table F03B11Z1 in database Business Data - CRP has the following physical columns:
17 juin 2009 17:37:55,682 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJEDUS
17 juin 2009 17:37:55,683 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJEDTY
17 juin 2009 17:37:55,683 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJEDSQ
17 juin 2009 17:37:55,683 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJEDTN
17 juin 2009 17:37:55,684 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJEDCT
17 juin 2009 17:37:55,684 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJEDLN
17 juin 2009 17:37:55,684 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJEDTS

...

17 juin 2009 17:37:55,732 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDI£
17 juin 2009 17:37:55,732 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDGM
17 juin 2009 17:37:55,733 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDGD
17 juin 2009 17:37:55,733 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDGY
17 juin 2009 17:37:55,733 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDG£
17 juin 2009 17:37:55,734 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDICM
17 juin 2009 17:37:55,734 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDICD
17 juin 2009 17:37:55,734 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDICY
17 juin 2009 17:37:55,735 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDIC£
17 juin 2009 17:37:55,735 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDSVM
17 juin 2009 17:37:55,735 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDSVD
17 juin 2009 17:37:55,736 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDSVY
17 juin 2009 17:37:55,736 [Line ?] [DEBUG ] OVIDAL - [JDBJ] Msg VJDSV£

...


[/ QUOTE ]

So it "sees" VJDI£ instead of VJDI#.

When looking at the table with squirrel sql via odbc or direct connection to the database I see VJDI#.
Also with iSeries navigator I see VJDI#.

I have tried re-deploying P03B11Z1, F03B11Z1 with no success.

Some people suggested to me it could be a CCSID problem, but if it would be the case, wouldnt we have a problem with every table of the system containing fields containing #in their names ?

I am pretty sure this is the problem but I dont know how to correct it.

Regards,

Olivier Vidal
 
Olivier,
No. If an individual table was generated or created by a user with a different CCSID, then the F03B11Z1 could have a different CCSID than any other/all tables. Please use the DSPFD command on the 400 to determine the CCSID of the F03B11Z1.

-Ethan
 
Back
Top