sqlstate:S1000 ???

[shine]

Hello all,
whn ever my user try to filter the date from p4210
it is not returing any data,but iam able to see the data in the table (utb)
blow wht i get in the jde .log

2380/2692 Thu Dec 01 20:39:48 2005 jdb_drvm.c938
JDB9900401 - Failed to execute db request

2380/2692 Thu Dec 01 20:39:48 2005 JDBODBC.C5459
ODB0000071 - SQLPrepare failed

2380/2692 Thu Dec 01 20:39:48 2005 JDBODBC.C5459
[IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0005 - Error occurred in the OS/400 database server code. - SQLSTATE: S1000

2380/2692 Thu Dec 01 20:39:48 2005 jdb_drvm.c938
JDB9900401 - Failed to execute db request

2380/2692 Thu Dec 01 20:39:48 2005 JDBODBC.C5459
ODB0000071 - SQLPrepare failed

2380/2692 Thu Dec 01 20:39:48 2005 JDBODBC.C5459
[IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0005 - Error occurred in the OS/400 database server code. - SQLSTATE: S1000

2380/2692 Thu Dec 01 20:39:48 2005 jdb_drvm.c938
JDB9900401 - Failed to execute db request


any idea/help?

IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0005 - Error occurred in the OS/400 database server code. - SQLSTATE: S1000

 

[Sebastian Sajaroff]

Hi,

I suggest you to stop JDE services, purge *SQLPKG files
(except those beginning with Q) and restart JDE.

 

[shine]

thanks.
i have sql pkgs under QGPL, which are FDAVJ,JAVAMIGBAA,LAUNCHVJA,
OEXPLORVJA,DEBUGGEVJA,CWBUNNAFBI,UTBBROWSVJA,VDTVJA.
can i delete these?

 

[Sebastian Sajaroff]

Hi,

Yes, you can.
DON'T DELETE packages beginning with letter Q.
Of course, all packages have to be deleted while
JDE services are stopped.

Regards,

 

[shine]

thanks sebastien,
Still i like to need little more confirmation.
i am having this problem on PD.
and whn i am doing a wrkobj *all/*all *sqlpkg. i am able to see sql pakgs which are not with "q" in lot sof libs(such as sopd,copy,codv,qgpl andmore)
do i need ot deelte the pkg under copd7334 or under qgpl?or all?

sorry , i am not much in CNC and my production is stopped becoz of this!

also do u have any docs or links abt how to do this safely?

 

[shawnscanlon]

Take a look at the attached document:

 

[shine]

Thank you verymuch .. IT WORKED!!