cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compression on 0IC_C03 fails

Former Member

on ‎05-06-2015 5:26 AM

0 Kudos

Hi All,

Could you please help me in getting this resolved as when i do compression on 0IC_C03 the Job fails

Please find the log below

2015-05-05 23:47:34 The identifier that starts with '[KEY_0IC_C03T] , F.[KEY_0IC_C03U] , F.[KEY_0IC_C031] , F.[KEY_0IC_C032] , F.[KEY_0IC_C033] , ... DBMAN 102 S

2015-05-05 23:47:34 Y_0IC_C035]' is too long. Maximum length is 128. DBMAN 102 S

2015-05-05 23:47:34 Collapse terminated: Data target 0IC_C03, from to 37672 RSM 747 S

2015-05-05 23:47:34 Report RSCOMP1 ended with errors RSM1 798 E

2015-05-05 23:47:34 Job cancelled after system exception ERROR_MESSAGE 00 564 A

Steps to replicate the same I have intially loaded the 0IC_C03 with No Marker Update unchecked once after the load from 2LIS_03_BX the compression is done.

2)During the load of 2LIS_03_BF with No Marker update Checked.

I get the job terminated and no dump but the job fails.

Please note all the configuration and pre-requistes are done. For more information, when i do the same with Marker update unchecked the compression happens.

The system information is

Database system : MSSQL

SAP_BW7400008SAPKW74008SAP Business Warehouse

SAP_ABA7400008SAPKA74008Cross-Application Component

Regards,

Raj

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
‎05-06-2015 1:36 PM
0 Kudos

Hi Ajay,

pls find the job log

Job log overview for job: BI_COMPDJYMY56YJXQ41RVYIOR40Z63E / 01030700

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

|Date |Time |Message text |Message class|Message no.|Message type|

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

|2015-05-06|01:03:07|Job started | 00 | 516 | S |

|2015-05-06|01:03:07|Step 001 started (program RSCOMP1, variant &0000000000042, user ID R0030044) | 00 | 550 | S |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|Performing check and potential update for status control table of 0IC_C03 | RSM1 | 490 | S |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|End of check and update for status control control table of 0IC_C03 | RSM1 | 544 | S |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|FB RSM1_CHECK_DM_GOT_REQUEST called from PRG RSSM_PROCESS_COMPRESS; row 000200 | RSM | 053 | S |

|2015-05-06|01:03:11|Request '37,674'; DTA '0IC_C03'; action 'C'; with dialog 'X' | RSM | 054 | S |

|2015-05-06|01:03:11|Leave RSM1_CHECK_DM_GOT_REQUEST in row 70; Req_State '' | RSM | 055 | S |

|2015-05-06|01:03:11|RSS2_DTP_RNR_SUBSEQ_PROC_SET GET_INSTANCE_FOR_RNR 37674 LINE 43 | RSAR | 051 | S |

|2015-05-06|01:03:11|RSS2_DTP_RNR_SUBSEQ_PROC_SET GET_TSTATE_FOR_RNR 7 LINE 243 | RSAR | 051 | S |

|2015-05-06|01:03:11|MERGE INTO [/BI0/E0IC_C03] AS E USING ( SELECT ( | DBMAN | 099 | I |

|2015-05-06|01:03:11| 23) AS [PDIMID] , 1177 AS [KEY_0IC_C03T] | DBMAN | 099 | I |

|2015-05-06|01:03:11|, [KEY_0IC_C03U] , [KEY_0IC_C031] , [KEY_0IC_C032] | DBMAN | 099 | I |

|2015-05-06|01:03:11| , [KEY_0IC_C033] , [KEY_0IC_C034] , [KEY_0IC_C035 | DBMAN | 099 | I |

|2015-05-06|01:03:11|] , [KEY_0IC_C036] ,SUM( [ISSBLOSTCK] ) AS [ISSBLO | DBMAN | 099 | I |

|2015-05-06|01:03:11|STCK] ,SUM( [ISSCNSSTCK] ) AS [ISSCNSSTCK] ,SUM( [ | DBMAN | 099 | I |

|2015-05-06|01:03:11|ISSQMSTCK] ) AS [ISSQMSTCK] ,SUM( [ISSSCRP] ) AS [ | DBMAN | 099 | I |

|2015-05-06|01:03:11|ISSSCRP] ,SUM( [ISSTOTSTCK] ) AS [ISSTOTSTCK] ,SUM | DBMAN | 099 | I |

|2015-05-06|01:03:11|( [ISSTRANSST] ) AS [ISSTRANSST] ,SUM( [ISSVALSCRP | DBMAN | 099 | I |

|2015-05-06|01:03:11|] ) AS [ISSVALSCRP] ,SUM( [ISSVALSTCK] ) AS [ISSVA | DBMAN | 099 | I |

|2015-05-06|01:03:11|LSTCK] ,SUM( [ISSVS_VAL] ) AS [ISSVS_VAL] ,SUM( [R | DBMAN | 099 | I |

|2015-05-06|01:03:11|ECBLOSTCK] ) AS [RECBLOSTCK] ,SUM( [RECCNSSTCK] ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|AS [RECCNSSTCK] ,SUM( [RECQMSTCK] ) AS [RECQMSTCK] | DBMAN | 099 | I |

|2015-05-06|01:03:11| ,SUM( [RECTOTSTCK] ) AS [RECTOTSTCK] ,SUM( [RECTR | DBMAN | 099 | I |

|2015-05-06|01:03:11|ANSST] ) AS [RECTRANSST] ,SUM( [RECVALSTCK] ) AS [ | DBMAN | 099 | I |

|2015-05-06|01:03:11|RECVALSTCK] ,SUM( [RECVS_VAL] ) AS [RECVS_VAL] ,SU | DBMAN | 099 | I |

|2015-05-06|01:03:11|M( [VENCONCON] ) AS [VENCONCON] FROM [/BI0/F0IC_C0 | DBMAN | 099 | I |

|2015-05-06|01:03:11|3] AS FACT WHERE[KEY_0IC_C03P] = 24 GROUP BY | DBMAN | 099 | I |

|2015-05-06|01:03:11|[KEY_0IC_C03U] , [KEY_0IC_C031] , [KEY_0IC_C032] , | DBMAN | 099 | I |

|2015-05-06|01:03:11| [KEY_0IC_C033] , [KEY_0IC_C034] , [KEY_0IC_C035] | DBMAN | 099 | I |

|2015-05-06|01:03:11|, [KEY_0IC_C036] ) AS F ON ( E.[KEY_0IC_C03P] = F. | DBMAN | 099 | I |

|2015-05-06|01:03:11|[PDIMID] AND E.[KEY_0IC_C03T] = F.[KEY_0IC_C03T] | DBMAN | 099 | I |

|2015-05-06|01:03:11|AND E.[KEY_0IC_C03U] = F.[KEY_0IC_C03U] AND E.[K | DBMAN | 099 | I |

|2015-05-06|01:03:11|EY_0IC_C031] = F.[KEY_0IC_C031] AND E.[KEY_0IC_C0 | DBMAN | 099 | I |

|2015-05-06|01:03:11|32] = F.[KEY_0IC_C032] AND E.[KEY_0IC_C033] = F.[ | DBMAN | 099 | I |

|2015-05-06|01:03:11|KEY_0IC_C033] AND E.[KEY_0IC_C034] = F.[KEY_0IC_C | DBMAN | 099 | I |

|2015-05-06|01:03:11|034] AND E.[KEY_0IC_C035] = F.[KEY_0IC_C035] AND | DBMAN | 099 | I |

|2015-05-06|01:03:11| E.[KEY_0IC_C036] = F.[KEY_0IC_C036] ) WHEN NOT MA | DBMAN | 099 | I |

|2015-05-06|01:03:11|TCHED THEN INSERT ( [KEY_0IC_C03P] , [KEY_0IC_C03T | DBMAN | 099 | I |

|2015-05-06|01:03:11|] , [KEY_0IC_C03U] , [KEY_0IC_C031] , [KEY_0IC_C03 | DBMAN | 099 | I |

|2015-05-06|01:03:11|2] , [KEY_0IC_C033] , [KEY_0IC_C034] , [KEY_0IC_C0 | DBMAN | 099 | I |

|2015-05-06|01:03:11|35] , [KEY_0IC_C036] , [RECBLOSTCK] , [ISSBLOSTCK] | DBMAN | 099 | I |

|2015-05-06|01:03:11| , [RECCNSSTCK] , [ISSCNSSTCK] , [RECQMSTCK] , [IS | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQMSTCK] , [RECTOTSTCK] , [ISSTOTSTCK] , [RECTRANS | DBMAN | 099 | I |

|2015-05-06|01:03:11|ST] , [ISSTRANSST] , [RECVALSTCK] , [ISSVALSTCK] , | DBMAN | 099 | I |

|2015-05-06|01:03:11| [RECVS_VAL] , [ISSVS_VAL] , [ISSSCRP] , [ISSVALSC | DBMAN | 099 | I |

|2015-05-06|01:03:11|RP] , [VENCONCON] ) VALUES ( F.[PDIMID] , F."[KEY_ | DBMAN | 099 | I |

|2015-05-06|01:03:11|0IC_C03T] , F.[KEY_0IC_C03U] , F.[KEY_0IC_C031] , | DBMAN | 099 | I |

|2015-05-06|01:03:11|F.[KEY_0IC_C032] , F.[KEY_0IC_C033] , F.[KEY_0IC_C | DBMAN | 099 | I |

|2015-05-06|01:03:11|034] , F.[KEY_0IC_C035] , F.[KEY_0IC_C036] ,0 ,0 , | DBMAN | 099 | I |

|2015-05-06|01:03:11|0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ) OUTP | DBMAN | 099 | I |

|2015-05-06|01:03:11|UT LEFT($action,1) INTO [##TCN_0IC_C03](ACTION) OP | DBMAN | 099 | I |

|2015-05-06|01:03:11|TION ( MAXDOP 1 ); | DBMAN | 099 | I |

|2015-05-06|01:03:11|Compression of InfoCube 0IC_C03 to request 37674 | DBMAN | 396 | S |

|2015-05-06|01:03:11|statistic data written | DBMAN | 102 | S |

|2015-05-06|01:03:11|Requirements check compelted: ok | DBMAN | 102 | S |

|2015-05-06|01:03:11|enqueue set: 0IC_C03 | DBMAN | 102 | S |

|2015-05-06|01:03:11|compond index checked on table: /BI0/E0IC_C03 | DBMAN | 102 | S |

|2015-05-06|01:03:11|pdim entry for recordtp1created 23 | DBMAN | 102 | S |

|2015-05-06|01:03:11|reference points have const. t-dimid: 1177 | DBMAN | 102 | S |

|2015-05-06|01:03:11|Loading of historical data switched on | DBMAN | 561 | S |

|2015-05-06|01:03:11|request statistics calculated for p-dimid 24 | DBMAN | 102 | S |

|2015-05-06|01:03:11|enqueue released: 0IC_C03 | DBMAN | 102 | S |

|2015-05-06|01:03:11|The identifier that starts with '[KEY_0IC_C03T] , F.[KEY_0IC_C03U] , F.[KEY_0IC_C031] , F.[KEY_0IC_C032] , F.[KEY_0IC_C033] , ...| DBMAN | 102 | S |

|2015-05-06|01:03:11|Y_0IC_C035]' is too long. Maximum length is 128. | DBMAN | 102 | S |

|2015-05-06|01:03:11|Collapse terminated: Data target 0IC_C03, from to 37,674 | RSM | 747 | S |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|Performing check and potential update for status control table of 0IC_C03 | RSM1 | 490 | S |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|End of check and update for status control control table of 0IC_C03 | RSM1 | 544 | S |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11|truncate table [TESTDATRNRPART0] | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL: 2015-05-06 01:03:11 R0030044 | DBMAN | 099 | I |

|2015-05-06|01:03:11| INSERT INTO @XSQL VALUES (' SELECT 0 FROM | DBMAN | 099 | I |

|2015-05-06|01:03:11|[TESTDATRNRPART0] WITH ( TABLOCKX HOLDLOCK ) | DBMAN | 099 | I |

|2015-05-06|01:03:11|WHERE 1 = 0 ' | DBMAN | 099 | I |

|2015-05-06|01:03:11|SQL-END: 2015-05-06 01:03:11 00:00:00 | DBMAN | 099 | I |

|2015-05-06|01:03:11|Compression of InfoCube 0IC_C03 to request 37674 | DBMAN | 396 | S |

|2015-05-06|01:03:11|statistic data written | DBMAN | 102 | S |

|2015-05-06|01:03:11|Requirements check compelted: ok | DBMAN | 102 | S |

|2015-05-06|01:03:11|enqueue set: 0IC_C03 | DBMAN | 102 | S |

|2015-05-06|01:03:11|compond index checked on table: /BI0/E0IC_C03 | DBMAN | 102 | S |

|2015-05-06|01:03:11|pdim entry for recordtp1created 23 | DBMAN | 102 | S |

|2015-05-06|01:03:11|reference points have const. t-dimid: 1177 | DBMAN | 102 | S |

|2015-05-06|01:03:11|Loading of historical data switched on | DBMAN | 561 | S |

|2015-05-06|01:03:11|request statistics calculated for p-dimid 24 | DBMAN | 102 | S |

|2015-05-06|01:03:11|enqueue released: 0IC_C03 | DBMAN | 102 | S |

|2015-05-06|01:03:11|The identifier that starts with '[KEY_0IC_C03T] , F.[KEY_0IC_C03U] , F.[KEY_0IC_C031] , F.[KEY_0IC_C032] , F.[KEY_0IC_C033] , ...| DBMAN | 102 | S |

|2015-05-06|01:03:11|Y_0IC_C035]' is too long. Maximum length is 128. | DBMAN | 102 | S |

|2015-05-06|01:03:11|Collapse terminated: Data target 0IC_C03, from to 37674 | RSM | 747 | S |

|2015-05-06|01:03:11|Report RSCOMP1 ended with errors | RSM1 | 798 | E |

|2015-05-06|01:03:11|Job cancelled after system exception ERROR_MESSAGE | 00 | 564 | A |

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Show replies
Show replies
Former Member
‎06-10-2015 4:57 PM
0 Kudos

Hello Folks

I faced the same issue.I used the function module for compression RSCDS_CONDENSE_CUBE with the selection for no marker update (reference point) and req id and it worked.You can try the same.

Regards

Narendra

former_member268087
Discoverer
‎07-01-2015 8:42 AM
0 Kudos

Yes, this works indeed. Narendra, you saved my life 🙂 and the afternoon.

Former Member
‎05-06-2015 5:47 AM
0 Kudos

Hi Rajkumar,

Run the specific dimensionneed of the cube in RSRV by choosing the All Elementary tests-> Transactional data-> Multiple entries in dimensions of a basis cube -> choose and exceute if founds any warings run correct error option in RSRV again. This will correct the error.

Test Multiple inputs in an InfoCube dimension was cancelled due to an

unknown error-- For this re run the RSRV again and this error not been appeared again. And finally the compression is happening correctly with out any issues.

And this note message no:- DBMAN368 states , this wont be any ISSUE with respect to data load and data summarizartion in cube output.

Thanks

Ajay Daggubati.

Show replies
Show replies
Former Member
‎05-06-2015 5:58 AM
0 Kudos

Hi Ajay,

Thanks for the quick reply. I have tried RSRV but i dont see any errors. The check went fine.

I also executed the report-RSCDS_MERGE_DUPL_REF_POINTS thinking that it may have some duplicate ref points. It went fine without any issues.

So i think still there is something which is at the Database level. Since when we do the compression without Marker Update Checked it is fine. But the same when Checked for compression of BF it fails.

Regards,

Raj

Former Member
‎05-06-2015 6:48 AM
0 Kudos

Hi Raj,

can you please copy and paste the entire error you are getting..

Thanks

Ajay.D

Ask a Question