Planned order creation - DBIF_RSQL_SQL_ERROR

Former Member — Fri, 23 Apr 2010 21:53:31 GMT

Hi ,

Recently we have done the ECC6.0 migration. Migration in the sense

Server A ECC6.0 Maxdb to Server B ECC6.0 Sqlserver.

we took the database export from server A and imported to Server B.

After completing the migration we are facing a problem.

Using Trx code MD11 I am creating Planned order. It is giving Planned order XXXXX will be created.

when I try to go back it shows Express document "update was terminated" received from Author ************.

Also when I go MD13 and try to retrive the same planned order it says the order XXXXX doesn't exists.

I am seeing a dump in ST22.Runtime error.

Error 22.04.2010 DBIF_RSQL_SQL_ERROR CX_SY_OPEN_SQL_DB

Cann't insert NULL into column "ADCODE" Table "RESB"

Column doesn't allow NULLS . Insert Fails.

But for server A with MaxDB I am able to create planned order.There it is not giving this error.After Migration only I am getting this error.

Any Help is Appreciated.

Regards,

Guru.

Re: Planned order creation - DBIF_RSQL_SQL_ERROR

Former Member — Sat, 24 Apr 2010 04:03:07 GMT

Hi,

Just check this link might help you.

Regards and Best wishes.

Former Member — Sat, 24 Apr 2010 05:04:43 GMT

HI,

REFER THE BELOW LINKS.

THESE LINKS MAY BE USEFULL FOR YOU.

THANKS & REGARDS,

SAKTHIVEL.VT