Data Warehousing Community Forum
February 10, 2012, 01:28:52 am

Pages: [1]   Go Down
  Print  
Author Topic: after adding delete triggers VAR_27026Error: Missing initial string value  (Read 8290 times)
randy_shandong
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 2


View Profile
« on: December 28, 2008, 09:07:36 pm »

Hi,

I am quite new to BI Apps, especially Informatica and DAC parts.

I am tring to add a delete triggers into execute plan of the DW. My source system is siebel 8.0 vertical. Before,I didn't add delete trigger,the execute plan named CRM Automotive-Customer_siebel 8.0_SHYY. It run successlly! Now when I add some delete triggers about s_org_ext,the question is appear. The SDE_OrgnizationDimension_LoadDeleterows session run failure. when I look the session logs ,it says the session logs was not created.

I am stuck, any help will be appreciated.

Thanks
Logged
randy_shandong
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 2


View Profile
« Reply #1 on: December 28, 2008, 09:08:42 pm »

This is my workflow logs .please help me


INFO : LM_36435 : (23864|31) Starting execution of workflow [SDE_OrganizationDimension_LoadDeletedRows] in folder [SDE_SBL_Vert_80_Adaptor] last saved by user [Administrator].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$$passInStatus], Value
  • .
INFO : LM_36330 [Sun Dec 28 22:37:28 2008] : (23864|31) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: Execution started.
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.Status], Value [STARTED].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.PrevTaskStatus], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.StartTime], Value [12/28/2008 22:37:28].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.EndTime], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.ErrorCode], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.ErrorMsg], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.SrcSuccessRows], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.SrcFailedRows], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.TgtSuccessRows], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.TgtFailedRows], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.TotalTransErrors], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.FirstErrorCode], Value [<null>].
TRACE : LM_36379 : (23864|31) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.FirstErrorMsg], Value [<null>].
INFO : LM_36522 : (23864|31) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: Started DTM process [pid = 21533] for this session instance.
INFO : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: LM_36033 [Connected to repository [Oracle_BI_DW_Base] running on server:port [crm2]:[5001] user [Administrator]].
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: CMN_1761 [Timestamp Event: [Sun Dec 28 22:37:31 2008]].
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: VAR_27026 [Error: Missing initial value for session parameter:[$DBConnection_OLAP].].
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: CMN_1761 [Timestamp Event: [Sun Dec 28 22:37:31 2008]].
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: TM_6270 [Error: Variable parameter expansion error.].
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: CMN_1761 [Timestamp Event: [Sun Dec 28 22:37:31 2008]].
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: TM_6163 [Error initializing variables and parameters for the paritition.].
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: CMN_1761 [Timestamp Event: [Sun Dec 28 22:37:31 2008]].
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: TM_6226 [ERROR:  Failed to initialize session [SDE_OrganizationDimension_LoadDeletedRows]].
ERROR : LM_36529 : (23864|33) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: The e-mail user name in the post session failure e-mail component for this session instance is empty.
ERROR : LM_36530 : (23864|33) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: Failed to send post session failure e-mail for this session instance.
ERROR : LM_36320 [Sun Dec 28 22:37:34 2008] : (23864|33) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: Execution failed.
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.Status], Value [FAILED].
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.PrevTaskStatus], Value [FAILED].
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.StartTime], Value [12/28/2008 22:37:28].
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.EndTime], Value [12/28/2008 22:37:34].
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.ErrorCode], Value [6270].
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.ErrorMsg], Value [TM_6270 Error: Variable parameter expansion error.].
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.SrcSuccessRows], Value
  • .
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.SrcFailedRows], Value
  • .
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.TgtSuccessRows], Value
  • .
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.TgtFailedRows], Value
  • .
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.TotalTransErrors], Value
  • .
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.FirstErrorCode], Value [27026].
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.FirstErrorMsg], Value [VAR_27026 Error: Missing initial value for session parameter:[$DBConnection_OLAP].].
WARNING : LM_36331 : (23864|33) Session task instance [SDE_OrganizationDimension_LoadDeletedRows] failed and its "fail parent if this task fails" setting is turned on.  So, Workflow [SDE_OrganizationDimension_LoadDeletedRows] will be failed.
TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$$passInStatus], Value
  • .
WARNING : LM_36539 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows]: Unable to unlink temporary parameter file [] with error [2] [No such file or directory]
ERROR : LM_36320 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows]: Execution failed.
Logged
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #2 on: December 29, 2008, 10:28:10 am »

Looks like messed up configuration. It's a whole series of cascading errors -
ERROR : TM_6292 : (21533|1) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: VAR_27026 [Error: Missing initial value for session parameter:[$DBConnection_OLAP].].

ERROR : LM_36529 : (23864|33) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: The e-mail user name in the post session failure e-mail component for this session instance is empty.
ERROR : LM_36530 : (23864|33) Session task instance [SDE_OrganizationDimension_LoadDeletedRows]: Failed to send post session failure e-mail for this session instance.

TRACE : LM_36379 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows].  Variable [$SDE_OrganizationDimension_LoadDeletedRows.FirstErrorMsg], Value [VAR_27026 Error: Missing initial value for session parameter:[$DBConnection_OLAP].].

WARNING : LM_36539 : (23864|33) Workflow [SDE_OrganizationDimension_LoadDeletedRows]: Unable to unlink temporary parameter file [] with error [2] [No such file or directory]
I have highlighted the three errors that I can see.

From the Informatica 8.1 troubleshooting guide -
Quote
VAR_27026Error: Missing initial string value for <variable>: <name>.
Cause:The Integration Service cannot find the initial string value for the specified
variable in the session parameter.
Action:Add the initial value in the parameter file.


And this part - "Unable to unlink temporary parameter file []"

This is what Informatica 8.1 troubleshooting guide says about this -
Quote
LM_36539<Session instance path>: Unable to unlink temporary parameter file
[parameter file name] with error [error number] [cause of error].

Cause:You ran a workflow on a server grid. The master server distributed the session
to a worker server. The worker server created a temporary parameter file in
$PMTempDir, but it failed to delete the file.
Action:Verify the worker server has the correct permissions to access $PMTempDir
and verify there is enough disk space. Or, you can manually delete the
temporary parameter file from the $PMTempDir directory.
Logged

If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
 
Jump to: