Parameters not getting used/skipped in "InvokeProcessActivity"

[Nandkumar Patel]

Hi,

    I am trying to pass the parameterized value for username and password to Invoke process Activity.
It call BCP.exe to move data from file to table in SQLSERVER database.

However executed the the Javelin flow executed but not loading the data in table. How I can make sure the username and password is initiated during the execution of command in "InvokeProcesActivity" ?

Could you please help ?

Regards,
Nandkumar Patel.

[Scott Schmitz]

Hello Nandkumar, have you tried running Javelin with Verbose Logging to see the details of the run?

[Nandkumar Patel]

Hi,

  I tried to run in Verbose mode and below is the log. Table not loaded and there is no error in Log file too.
The paraemter name used in BCP command are "guid" and gpwd".

Please see below log in verbose mode:

2020-06-10 06:21:22 - Run flow: C:\Users\patelna\Desktop\JTest\CURL Chnages\3290_CLS_QVTest.vwf2020-06-10 06:21:22 - Run flow: C:\Users\patelna\Desktop\JTest\CURL Chnages\3290_CLS_QVTest.vwf2020-06-10 06:21:23 - Running Test Case: Flowchart2020-06-10 06:21:23 - Executing Step: FileActivity2020-06-10 06:21:23 - With Params:2020-06-10 06:21:23 - Variable Name = Content Value = <NULL>2020-06-10 06:21:23 - Variable Name = TargetPath Value = <NULL>2020-06-10 06:21:23 - Variable Name = Timeout Value = 02020-06-10 06:21:23 - Variable Name = Path Value = C:\ParameterisedPasswordFile\TDMAPPS01_UID_PASS.txt2020-06-10 06:21:23 - Executing Step: InvokeProcessActivity2020-06-10 06:21:23 - With Params:2020-06-10 06:21:23 - Variable Name = TerminateProcessAfterTimeInSecs Value = 02020-06-10 06:21:23 - Variable Name = Timeout Value = 02020-06-10 06:21:23 - Variable Name = ExecutableName Value = bcp.exe2020-06-10 06:21:23 - Variable Name = WorkingDirectory Value = C:\Program Files\Microsoft SQL Server\110\Tools\Binn2020-06-10 06:21:23 - Running Test Case: Flowchart2020-06-10 06:21:23 - Test Case: Flowchart Execution CompleteExecution complete

[Scott Schmitz]

A good way to troubleshoot whether your parameter string resolves properly with embedded Variables is to Insert a Log Activity step (Control Flow/Log in the Javelin toolbox) in your Javelin process flow just before the bcp step.  Copy "Arguments" from your  bcp InvokeProcessActivity step into "MessageToLog" in the Log Activity step.   Run Verbose Logging and you will see the fully formed parameter string, which you can review to ensure that it shows as expected.

I've been able to run bcp ok, here's an example of the contents of my Arguments param:   (hostname, guid, gpwd are variables, and I'm exporting the "persons" table from the Orders database).

"persons out ""C:\temp\tdmcmty\sqlout.dat"" -S " +hostname+ " -U " +guid+ " -P " +gpwd+ " -d Orders -c -t"

[Nandkumar Patel]

Hi,

  Thanks for your help. I tried the option you have suggested but it is still not taking the parameters and not showing any error too.

Below is the details 
1. Command used in 2 ways

"db.dbo.recordstable in D:\ab\SYSREC47.dat -f D:\ab\RDS01.txt -e D:\ab\R01.txt -q -U " +guid+ " -P " +gpwd+ " -S DBTD01S\ACQLINST01 -v"

"db.dbo.recordstable in ""D:\ab\SYSREC47.dat"" -f ""D:\ab\RDS01.txt"" -e ""D:\ab\R01.txt"" -q -U " +guid+ " -P " +gpwd+ " -S DBTD01S\ACQLINST01 -v"

2. Log outcome showing guid and gpwd as blank

Running flow...Running flow...2020-06-11 04:04:40 - Run flow: C:\Users\patelna\Desktop\JTest\CURL Chnages\3290_CLS_IT_Test.vwf2020-06-11 04:04:40 - Running Test Case: Flowchart2020-06-11 04:04:40 - Executing Step: FileActivity2020-06-11 04:04:40 - With Params:2020-06-11 04:04:40 - Variable Name = Content Value = <NULL>2020-06-11 04:04:40 - Variable Name = TargetPath Value = <NULL>2020-06-11 04:04:40 - Variable Name = Timeout Value = 02020-06-11 04:04:40 - Variable Name = Path Value = C:\ParameterisedPasswordFile\TDMAPPS01_UID_PASS.txt2020-06-11 04:04:40 - Executing Step: InvokeProcessActivity2020-06-11 04:04:40 - With Params:2020-06-11 04:04:40 - Variable Name = TerminateProcessAfterTimeInSecs Value = 02020-06-11 04:04:40 - Variable Name = Timeout Value = 02020-06-11 04:04:40 - Variable Name = ExecutableName Value = bcp.exe2020-06-11 04:04:40 - Variable Name = WorkingDirectory Value = C:\Program Files\Microsoft SQL Server\110\Tools\Binn2020-06-11 04:04:40 - Executing Step: LogActivity2020-06-11 04:04:40 - With Params:2020-06-11 04:04:40 - Variable Name = Timeout Value = 02020-06-11 04:04:40 - Variable Name = MessageToLog Value = val of args   CATDMDataMart.dbo.CLS_DATA_3290_QV_WS_EXTRACT_RECORD in D:\mainframe_techtia\CLS_3290_QV_SYSREC47.dat -f D:\mainframe_techtia\CLS_3290_QV_CARDS01.txt -e D:\mainframe_techtia\ERROR01.txt -q -U  -P  -S CWB02TDMDBTD01S\TSQLINST01 -v2020-06-11 04:04:40 - val of args   CATDMDataMart.dbo.CLS_DATA_3290_QV_WS_EXTRACT_RECORD in D:\mainframe_techtia\CLS_3290_QV_SYSREC47.dat -f D:\mainframe_techtia\CLS_3290_QV_CARDS01.txt -e D:\mainframe_techtia\ERROR01.txt -q -U  -P  -S CWB02TDMDBTD01S\TSQLINST01 -v2020-06-11 04:04:40 - Running Test Case: Flowchart2020-06-11 04:04:40 - Test Case: Flowchart Execution CompleteExecution complete

Let me know if you need any more details.

Regards,
Nandkumar Patel

[Scott Schmitz]

Can you confirm that if you take the arguments output (as shown in your log):

CATDMDataMart.dbo.CLS_DATA_3290_QV_WS_EXTRACT_RECORD in D:\mainframe_techtia\CLS_3290_QV_SYSREC47.dat -f D:\mainframe_techtia\CLS_3290_QV_CARDS01.txt -e D:\mainframe_techtia\ERROR01.txt -q -U -P -S CWB02TDMDBTD01S\TSQLINST01 -v 

and put bcp before it and insert your userid & password in the appropriate places, that it will run to completion?