SAP Knowledge Base Article - Preview

2129688 - Global Variable errors with Data Services

Symptom

  • Global Variable value changes unexpectedly.
  • The following error happens when trying to save job.

Internal application error:

Cannot process the object definition when saving the object.
Please report this error to your software vendor.
This error occurs when the application generates language it cannot save.
To work around this error please do the following:
1. Analyze the error message and the generated language below to localize the problem.
2. Find the name of the object that causes this problem.
3. Open this object and try to fix the error.


Error message:
Cannot save <SetOptions> for repository object <Language Object New_Job>. Additional database information: <Cannot save <Storing SetOption: <job_GV_$test=1> > into the repository. Additional database information: <SQL submitted to ODBC data source <<Server Name>,<Port Number>> resulted in error <[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__AL_SETOP__486F8421145C0A3F'. Cannot insert duplicate key in object 'dbo.AL_SETOPTIONS'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.>. The SQL submitted is <INSERT INTO "AL_SETOPTIONS" ("PARENT_OBJID", "PARENT_OBJTYPE", "CALL_OBJID", "CALL_OBJTYPE", "OPTION_NAME", "OPTION_VALUE", "OVERFLOW_KEY")
VALUES (96, 0, N'Not Applicable', N'Not Applicable', N'job_GV_$test', N'1', NULL)
>.>.>.


Incorrect Language:
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Thu Feb 12 14:04:44 2015' , "ActaName_3" = 'RDate_modified' , "ActaValue_3" = 'Thu Feb 12 14:08:15 2015' )
CREATE SESSION New_Job::'d2ac71db-ee9b-46a9-84d8-9e10725c6ff9'( )
DECLARE
     GLOBAL $Test int;
BEGIN
END

SET("job_GV_$Test" = '2',
"job_GV_$test" = '1',
"job_checkpoint_enabled" = 'no',
"job_collect_statistics" = 'no',
"job_collect_statistics_monitor" = 'no',
"job_enable_assemblers" = 'yes',
"job_enable_audit" = 'yes',
"job_enable_dataquality" = 'yes',
"job_export_repo" = 'no',
"job_export_reports" = 'no',
"job_guid" = 'd2ac71db-ee9b-46a9-84d8-9e10725c6ff9',
"job_isrecoverable" = 'no',
"job_mode" = 'Multi-Process',
"job_monitor_sample_rate" = '1000',
"job_monitor_timer_rate" = '5',
"job_name" = 'New_Job',
"job_print_version" = 'no',
"job_testmode_enabled" = 'no',
"job_trace_abapquery" = 'no',
"job_trace_all" = 'no',
"job_trace_ascomm" = 'no',
"job_trace_assemblers" = 'no',
"job_trace_audit" = 'no',
"job_trace_dataflow" = 'yes',
"job_trace_idoc_file" = 'no',
"job_trace_memory_loader" = 'no',
"job_trace_memory_reader" = 'no',
"job_trace_optimized_dataflow" = 'no',
"job_trace_parallel_execution" = 'no',
"job_trace_rfc_function" = 'no',
"job_trace_row" = 'no',
"job_trace_script" = 'no',
"job_trace_session" = 'yes',
"job_trace_sql_only" = 'no',
"job_trace_sqlfunctions" = 'no',
"job_trace_sqlloaders" = 'no',
"job_trace_sqlreaders" = 'no',
"job_trace_sqltransforms" = 'no',
"job_trace_stored_procedure" = 'no',
"job_trace_system" = 'no',
"job_trace_table" = 'no',
"job_trace_table_reader" = 'no',
"job_trace_transform" = 'no',
"job_trace_userfunction" = 'no',
"job_trace_usertransform" = 'no',
"job_trace_workflow" = 'yes',
"job_type" = 'batch',
"job_use_statistics" = 'yes',
"locale_codepage" = '<default>',
"locale_language" = '<default>',
"locale_territory" = '<default>')
. (BODI-1112353)


Read more...

Environment

  • Data Services 4.0 SP3 Patch5
  • Data Services 4.2 SP4

Product

SAP Data Services 4.0 ; SAP Data Services 4.2

Keywords

ds, global variable, parameter, strange, phenomenon , KBA , EIM-DS-EXE , Data Services Job Execution , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.