DBIF_DSQL2_SQL_ERROR - invalid column name "originating_server"

[Former Member]

Hello everyone.

When i try to enter in Tx db13 o got the following dump :

DBIF_DSQL2_SQL_ERROR

Fehlertext der Datenbank...: "Invalid column name 'originating_server'."
Auslösende SQL-Anweisung...: "FETCH NEXT "
Internal call code.........: "[DBDS/NEW DSQL]"
Please check the entries in the system log (Transaction SM21).

You may able to find an interim solution to the problem
in the SAP note system. If you have access to the note system yourself,
use the following search criteria:
DBIF_DSQL2_SQL_ERROR" C
SAPLSFMSS_JOBS" or "LSFMSS_JOBSU22"
MSS_GET_JOB_AND_HISTORY_INFO"

I look in SQL server and in table msdb.dbo.sysjobs there is a column with name "'originating_server_id" but with this name 'originating_server" there is no column name .

The system was migrated from HP-UX ( oracle ) to Windows ( MSSQL)

Windows server 2003 x64 R2 (SP2)

MSSQL 2005 version 9

CRM 3.1 kernel 6.40 version 390

What can i do to solve this issue?

Tnks

[rupali_karbhari3]

Hi,

As per SAP Note # 1472581 , it is recommanded after upgrade execute the report in SQL 2005 or SQL 2000 to delete the jobs.

program name : RSMSSDELSQLJOBS can be used for deleting old jobs.

Regards,

[former_member184473]

Hello,

Remove the following jobs:

*_Cleanup_Saplocks

*_Drop_Unused_Sps

*_MSSQL_COLLECTOR

*_Update_Tabstats

and recreate them properly afterwards with:

SE38 -> MSSPROCS -> execute all scripts

Regards,

Eduardo Rezende