SUM - SPAM/SAINT 7.3 Update using SQL2012

[marcello_akaboshi]

Hi,

I installed a SAP NW BW 7.3 in Windows Server 2012 / SQL 2012 and I'm trying to update SPAM/SAINT via SUM, but this errors occurs:

1 ETQ359 RFC Login to: System="BWD", AsHost="atlas" Nr="00", GwHost="atlas", GwService="sapgw00"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20140527175641 

1 ETQ233 Calling function module "OCS_API_DELETE_QUEUE" by RFC

1EETQ235 Call of function module "OCS_API_DELETE_QUEUE" by RFC failed (error-status "3")

2EETQ360 RFC of "OCS_API_DELETE_QUEUE" failed:

2EETQ361 code/exception  : 3

2EETQ362 key             : DBIF_RSQL_SQL_ERROR

2EETQ399 SQL error 515 while accessing table PAT05.

4 ETQ010 Date & Time: 20140527175641 

1EETQ399 Last error code set is: RFC error system BWD nr 00 function 'OCS_API_DELETE_QUEUE' failed with code 3 key DBIF_RSQL_SQL_ERROR: SQL error 515 while accessing table PAT05.

1EETQ204 Upgrade phase "SPAMCHK_INI" aborted with severe errors ("20140527175641")

And generate these two short dumps:

1)

Category               ABAP Server Resource Shortage

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

Date and Time          27.05.2014 18:32:53

Short text

     SQL error 515 while accessing table "PAT05".

What happened?

     Database error text: "Cannot insert the value NULL into column

      'DDIC_ACT_SUBSET', table 'BWD.bwd.PAT05'; column does not allow nulls. UPDATE

      fails."

2)

Category               ABAP Server Resource Shortage

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

Date and Time          27.05.2014 18:45:59

Short text

     SQL error 515 while accessing table "PATHISTORY".

What happened?

     Database error text: "Cannot insert the value NULL into column 'DACT_SUBSET',

      table 'BWD.bwd.PATHISTORY'; column does not allow nulls. INSERT fails."

Can anyone help me?

I didn't find any SAP note, or documentation about this problem.

Thanks!

Marcello

[marcello_akaboshi · Accepted solution]

To solve the issue I re-install the system.

Thanks

[Reagan]

Check what the SAP note 1676665 - Setting up Microsoft SQL Server 2012 says about DACT_SUBSET table error.

Regards

RB

[marcello_akaboshi]

Hi Reagan,

I read this note, but the solution is to re-install the application.

I will do this in last case.

Thanks!

[Sriram2009]

Hi

Just do the full restart and then try again in the same phase

BR

SS

[marcello_akaboshi]

The full restart doesn't works.

Thanks..