ODBC Error - Undefined database failure. . - SQLSTATE: 00000

[sputnik]

Hi people,

we just migrated to SQL2008/Win2008 x64 (ERP8/SP24.1.1) from SQL200/Win2003. Migrated all servers to VMWare (running on Netapp SAN),(excl. QA layer which resides on physical boxes - testing). We have two jobs going into error (looks like a random issue as the jobs are scheduled daily via JDE scheduler ). The error message in the JDE log is:

5580/3952 Tue Jul 27 00:35:46 2010 jdbodbc.C5583
ODBC Error - Undefined database failure.
. - SQLSTATE: 00000

5580/3952 Tue Jul 27 00:35:46 2010 JDB_DRVM.C988
JDB9900401 - Failed to execute db request

5580/3952 Tue Jul 27 00:35:46 2010 ODBC_P1.C1586
ODB0000179 - Multi-row SQLExtendedFetch failed in Table(1st) F4106
Database Business Data - PROD

5580/3952 Tue Jul 27 00:35:46 2010 ODBC_P1.C1591
[Microsoft][ODBC Driver Manager] Function sequence error - SQLSTATE: S1010

5580/3952 Tue Jul 27 00:35:46 2010 JDB_DRVM.C1048
JDB9900172 - Failed to exeute db fetch

Did anyone saw the SQLSTATE: 00000 error before (maybe in combination SQL2008 x64 or VM?

Thanks in advance,

Regards,

Adrian

 

[Sebastian Sajaroff]

Hi,

1.Have you checked that your SQL2008 server is at the
proper SP level? (check on MTRs, I think it's SP1)
2.Have you checked that the ODBCs have been created
using the driver SQL Native Client 10.0?

Good luck!

 

[Ritchie_]

sql version is according to the MTR sql 2008 sp1 (10.00.2531)
and the odbcs have indeed been created with the driver SQL Native Client 10.0...otherwise it would not even want to connect..

It's only with a few job which are scheduled.
One of them (an data extraction job) only failed last tuesday morning as well as this tuesday morning. Rest of the week it ran fine.

Another one (integrity report) fails every day but resubmitting it manually works fine. That same report also has another version scheduled which runs fine.


(I'm a colleague of Sputnik)

 

[brother_of_karamazov]

[ QUOTE ]
Hi people,

we just migrated to SQL2008/Win2008 x64 (ERP8/SP24.1.1) from SQL200/Win2003. Migrated all servers to VMWare (running on Netapp SAN),(excl. QA layer which resides on physical boxes - testing). We have two jobs going into error (looks like a random issue as the jobs are scheduled daily via JDE scheduler ). The error message in the JDE log is:

5580/3952 Tue Jul 27 00:35:46 2010 jdbodbc.C5583
ODBC Error - Undefined database failure.
. - SQLSTATE: 00000

5580/3952 Tue Jul 27 00:35:46 2010 JDB_DRVM.C988
JDB9900401 - Failed to execute db request

5580/3952 Tue Jul 27 00:35:46 2010 ODBC_P1.C1586
ODB0000179 - Multi-row SQLExtendedFetch failed in Table(1st) F4106
Database Business Data - PROD

5580/3952 Tue Jul 27 00:35:46 2010 ODBC_P1.C1591
[Microsoft][ODBC Driver Manager] Function sequence error - SQLSTATE: S1010

5580/3952 Tue Jul 27 00:35:46 2010 JDB_DRVM.C1048
JDB9900172 - Failed to exeute db fetch

Did anyone saw the SQLSTATE: 00000 error before (maybe in combination SQL2008 x64 or VM?

Thanks in advance,

Regards,

Adrian

[/ QUOTE ]

The data you are querying, does it contain a column defined as TEXT? Not CHAR, VARCHAR but TEXT?

 

[Ritchie_]

When I check the sql 2008 DB with the query
SELECT * FROM INFORMATION_SCHEMA.Columns where DATA_TYPE='text'
I get that F00165 column GDTXVC is text

Did check the setting in the old sql2000 db and there it is also 'text'
never had problems whit the job when we were on that DB.

When I do check the column definition in JDE, however, it is set as VARCHAR.

 

[brother_of_karamazov]

[ QUOTE ]
When I check the sql 2008 DB with the query
SELECT * FROM INFORMATION_SCHEMA.Columns where DATA_TYPE='text'
I get that F00165 column GDTXVC is text

Did check the setting in the old sql2000 db and there it is also 'text'
never had problems whit the job when we were on that DB.

When I do check the column definition in JDE, however, it is set as VARCHAR.

[/ QUOTE ]


https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=646037.1