Database error 102 at EXE Incorrect syntax near ‘timestamp’

[Former Member]

hellow experts,

i receive this error in sm21

the error il caused by RSDB2DAL report, but this report does not verify the DB2-based-system,

i check st22 no dump found,

tnks for help

best regards

[former_member182967 · Accepted solution]

Hello Jaafar,

Since the error or warning description is short, please refer to note 1848921 - Errors caused by report RSDB2DAL after applying support packages

Hope it help you.

Regards,

Ning Tong

[Former Member · Accepted solution]

hellow Ning,

tnaks for reply,

in the note 1848921, i found to apply the note OSS 1508357, no im going to apply the note in the developpement environement than i generate un OT to transport it in the product environement,

regard

Jaafar

[Former Member]

Hi Jaafar,

Please be aware that OSS note 1508357 you'll be applying is applicable for DB2.

As other colleagues this one seems fit to your scenario. Did you try it?

1848921 - Errors caused by report RSDB2DAL after applying support packages

Also I would recommend to clean you monitoring tables via this function module (sm37):

SWNC_COLLECTOR_CLEAN_SWNCMONI

And you could have a look at TCOLL table via se14, whether it has some weird entries.

Regards,

Serhat

[Former Member]

Hellow thank Ning and Serhat,

i have test the solution in TESTBED but not yet in the PRODUCTION system, for tell you the updates, the error was disappear from log sm21,

thanks so much best regards,

Jaafar

[former_member207186]

Hi Jaafar,

Thank you for your feedback and for the good news. It is our pleasure to assist you.

Regards,

Bíborka

[Former Member]

thanks Biborka

[former_member207186]

Hi,

Regarding this issue please refer to SAP KBA 1848921 - Errors caused by report RSDB2DAL after applying support packages for troubleshooting.

Regards,

Bíborka

[Former Member]

hellow,

thank for reply

im going to apply the SAP note : 1508357 and i will see after

regards,

Jaafar

[former_member207186]

Hi,

Thank you for your feedback. Please update us on the status after you applied the SAP Note as described in the suggested SAP KBA.

Regards,

Bíborka