Unable to create task list

[former_member188058]

Hi Experts,

In continuation of my earlier issue (which was fixed), now i have another issue related to creation of task list. All consistency checks are green, and when i click on "Create Task list" i get below error:

"Error writing to table /TMWFLOW/PROJCTC" followed by another "Error creating task list M000000000, transaction cancelled"

Please help.

Regards,

Imran

[hugo_amo · Accepted solution]

Hi Imran,

I think the solution for this issue is explained in :

https://wiki.wdf.sap.corp/wiki/display/CHARM/001+-+Failed+to+create+new+task+list+due+to+wrong+numbe...

Hope it helps.

Regards,

Hugo Amo.

[former_member188058 · Accepted solution]

Hi Hugo Amo,

Thanks for sending the link. but unfortunately i am unable to open the link. Does this require any login credentials?

Else, can i request you to please post the content of the link for everyone benefit.

Awaiting your response.

Regards,

Imran

[former_member188058 · Accepted solution]

Hi,

Bringing it on top....Can anyone access the above link and if yes, please post the solution described.

Is there also an alternate solution for this issue?

Please help.

Regards,

Imran

[hugo_amo · Accepted solution]

Hi Imran,

This is said in the link:

Symptom:
An error is raised when an Urgent Change or an project cylce tasklist is created. The system may prompt message that a technical problem occurred when RFC function module /TMWFLOW/HFIX_TASKLIST_CREATE was accessed ( Message no. SOCM_ACTION_LOG 025 ); or you may notice runtime error CX_SY_OPEN_SQL_DB within function module /TMWFLOW/TL_CRT_GENERATE.
One example is customer message 753820 2011(RRSOLM71: ChaRM/Urgent correction - no active tasklist).

Root Cause:
Error caused within FM /TMWFLOW/TL_CRT_GENERATE (generating the task list) or /TMWFLOW/VARIANT_CREATE (generating task list program variant). The system is using duplicate task list ID which is read from FM NUMBER_GET_NEXT for object /TMWFLOW/M or /TMWFLOW/V; this causes SQL error when inserting table entries.
According to SAP Implementation Guide instruction in transaction SPRO; the “From number” of internal of Number Range object /TMWFLOW/M and /TMWFLOW/V should be 000000001. However in the customer’s system, the wrong “From number” of internal of Number Range object /TMWFLOW/M and /TMWFLOW/V was set up which will cause duplicate task list ID due to internal issue within FM NUMBER_GET_NEXT. The entry is incorrectly initialized in include LAGS_SISE_UTILF01 before SAP note 1576472 was implemented.

Solution:
Change the number ranger interval manually in SE16 with debugger as below according to SAP Implementation Guide instruction for following objects;

• Object /TMWFLOW/M (CHAR9, used for generate Task List ID) 
  • No.: 01 
  • From number: 000000001 
  • To number: 999999999 
  • Current number: XXX ( the existing Number Range interval current number) 
  • Ext: not checked
• Object /TMWFLOW/D (CHAR14, not used so far) 
  • No.: 01 
  • From number: 000000001 
  • To number: 999999999 
  • Current number: XXX ( the existing Number Range interval current number) 
  • Ext: not checked
• Object /TMWFLOW/V (CHAR9, used for generate Task List program variant) 
  • No.: 01 
  • From number: 00000000000001 
  • To number: 99999999999999 
  • Current number: XXX ( the existing Number Range interval current number) 
  • Ext: not checked

Regards,

Hugo

[former_member188058 · Accepted solution]

Thanks Hugo. Issue resolved.

Once manual changed the interval, you need to close all the existing task list, refresh the buffer for /tmwflow/m object (using SM56) and relogin to system. Now the task list gets created successfully.

Regards,

Imran