Unable to open Job(String index out ofrange:-1)Infosphere8.5

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
kirankumarreddydesireddy
Participant
Posts: 110
Joined: Mon Jan 11, 2010 4:22 am

Unable to open Job(String index out ofrange:-1)Infosphere8.5

Post by kirankumarreddydesireddy »

Hi Ray

We have installed Infosphere 8.5 server edition on Windows 2003 server.We have exported a project from Ascential Datastage 7.5v Windows 2003 server and imported into Infosphere 8.5v.

When we tried to open some of subsequences from the main Sequence.we are getting the below error.

Unable to open the Job

String index out of range: -1

However for some of the subsequences,we are able to open them without any error.

For those subsequences which failed to open,the parameters defined earlier(in the 7.5v import) are not seen in the properties tab from the main sequence,when we opened that subsequence from the main sequence.



The error is shown below :


Unable to open the Job

String index out of range: -1

This error occurred on 7/21/2011 at 5:28 AM (Standard format: 2011/07/21 05:28:52)

Product Version: 8.5.0.0
Client tag: 8df00226-3932-4375-99de-43c973f54e06
See log: C:\Documents and Settings\etltestadmin\ds_logs\dstage_wrapper_trace_16.log
Application: DSDesign.exe (PID 5820)
Operating System: Windows Server 2003 5.2 Service Pack 2
.NET Framework version: 1.1.4322.2443
Machine Name: DSETLTEST1HE
User Name: etltestadmin
Language: English (United States)
Time Zone: Central Daylight Time

Error message:
Unable to open the Job



String index out of range: -1

Exception type: java/lang/StringIndexOutOfBoundsException
Exception message: String index out of range: -1
Exception stack trace:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.StringBuffer.deleteCharAt(StringBuffer.java:319)
at com.ascential.dstage.proxies.PropTable.buildPropValues(PropTable.java:152)
at com.ascential.dstage.proxies.PropTable.getPropValuesForCollection(PropTable.java:67)

Loaded modules:
D:\IBM\InformationServer\Clients\Classic\vmtextext.ocx 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\VMDSToolsOptionsManager.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsstgs.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsstge.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsssvENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdssedENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsrpsENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsrpos.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsquerymsgboxENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\VMDSQueryMsgBox.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdspass.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsparENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsosvENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsobj.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsjobseqpgENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsjobseqfrmENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsjbsENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsjbs.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsgtxENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsexpr.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsesvENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsedit.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsdesoptionsENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsdesigneroptions.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdsdesENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\vmdscvtENU.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\magiclocallibrary.dll 1.7.4.1
D:\IBM\InformationServer\Clients\Classic\jobseqpages.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\JobSeqFrame.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\interop.vba.dll 6.0.0.0
d:\ibm\informationserver\clients\classic\interop.datastage.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.win32interop.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.utility.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.repositoryview.operationmanager.operations.builtin.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.repositoryview.operationmanager.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.repositoryview.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.repositorycominterop.entrypoint.exe 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.repositorycominterop.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.repositoryaccess.typedefinitions.builtin.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.repositoryaccess.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.localization.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.genericcontrols.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\IBM.DataStage.GenericControls.ActiveXDotNetShim.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.find.operations.builtin.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.diffapi.shared.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.diff.operations.menu.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.componentexport.operations.builtin.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ibm.datastage.componentexport.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\iacomsourcetargetassistant.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\iacomnewtemplate.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\iacomnewjob.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\iacommoncontrols.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\iacommon.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\iacominterfaces.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\iaassistants.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\dssingleton.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\dsrvcENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\dsjsjobgenENU.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\dsjsjobgen.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\DSDesign.exe 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\DSComponents.dll 8.5.0.0
D:\IBM\InformationServer\Clients\Classic\converterobjecteb.dll 8.5.0.0
d:\ibm\informationserver\clients\classic\ascential.datastage.dll 8.5.0.0
d:\ibm\informationserver\asbnode\lib\dotnet\metadata_services_cs.dll 0.8.0.0
d:\ibm\informationserver\asbnode\lib\dotnet\invocation_cs.dll 0.8.0.0
d:\ibm\informationserver\asbnode\lib\dotnet\dstage_wrapper_cs.dll 8.5.0.0
d:\ibm\informationserver\asbnode\lib\dotnet\ascential.datastage.attach.com.attachservice.dll 8.5.0.0
d:\ibm\informationserver\asbnode\lib\dotnet\acs_common_cs.dll 0.8.0.0
d:\ibm\informationserver\asbnode\lib\dotnet\acs_client_cs.dll 0.8.0.0
d:\ibm\informationserver\asbnode\apps\proxy\dotnet\xmogrt.dll 3.1.6.1
d:\ibm\informationserver\asbnode\apps\proxy\dotnet\netrtsn.dll 3.1.0.0
d:\ibm\informationserver\asbnode\apps\proxy\dotnet\MSVCP71.dll 7.10.3077.0
D:\IBM\InformationServer\ASBNode\apps\jre\bin\zip.dll 6.0.0.0
D:\IBM\InformationServer\ASBNode\apps\jre\bin\vmi.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\nio.dll 6.0.0.0
D:\IBM\InformationServer\ASBNode\apps\jre\bin\net.dll 6.0.0.0
D:\IBM\InformationServer\ASBNode\apps\jre\bin\jsig.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\jclscar_24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\java.dll 6.0.0.0
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9zlib24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9vrb24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9vm24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9vm\jvm.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9ute24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9trc24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\J9THR24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\J9PRT24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9jvmti24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9jit24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\J9HOOKABLE24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9gc24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9dyn24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9dmp24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\j9bcv24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\iverel24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\HYTHR.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\hyprtshim24.dll 2.4.0.54049
D:\IBM\InformationServer\ASBNode\apps\jre\bin\fontmanager.dll 6.0.0.0
D:\IBM\InformationServer\ASBNode\apps\jre\bin\dcpr.dll 6.0.0.0
D:\IBM\InformationServer\ASBNode\apps\jre\bin\awt.dll 6.0.0.0
D:\IBM\INFORM~1\Clients\Classic\vmido32.ocx 1.1.0.61
D:\IBM\INFORM~1\Clients\Classic\ocigui9.dll 8.5.0.0
D:\IBM\INFORM~1\Clients\Classic\guisupp85.dll 8.5.0.0
D:\IBM\INFORM~1\Clients\Classic\DSRPC32.dll 8.5.0.1
D:\IBM\INFORM~1\Clients\Classic\DSOBJE~1.DLL 1.0.0.1
D:\IBM\INFORM~1\Clients\Classic\DSCLNT32.dll 1.0.0.1
D:\IBM\INFORM~1\Clients\Classic\db2gui.dll 8.5.0.0
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6002.22507_x-ww_C7DAD021\gdiplus.dll 5.2.6002.22507
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.4770_x-ww_05FDF087\comctl32.dll 6.0.3790.4770
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_5.82.3790.4770_x-ww_A689AB02\COMCTL32.dll 5.82.3790.4770
C:\WINDOWS\system32\xpsp2res.dll 5.2.3790.3959
C:\WINDOWS\system32\WSOCK32.dll 5.2.3790.0
C:\WINDOWS\System32\wshtcpip.dll 5.2.3790.3959
C:\WINDOWS\system32\WS2HELP.dll 5.2.3790.3959
C:\WINDOWS\system32\WS2_32.dll 5.2.3790.3959
C:\WINDOWS\system32\WLDAP32.dll 5.2.3790.3959
C:\WINDOWS\system32\WINSPOOL.DRV 5.2.3790.3959
C:\WINDOWS\System32\winrnr.dll 5.2.3790.3959
C:\WINDOWS\system32\WININET.dll 7.0.6000.17096
C:\WINDOWS\system32\VERSION.dll 5.2.3790.3959
C:\WINDOWS\system32\userenv.dll 5.2.3790.3959
C:\WINDOWS\system32\USER32.dll 5.2.3790.4033
C:\WINDOWS\system32\urlmon.dll 7.0.6000.17096
C:\WINDOWS\SYSTEM32\TDBG5.OCX 5.0.0.211
C:\WINDOWS\system32\tabctl32.ocx 6.0.81.69
C:\WINDOWS\system32\sxs.dll 5.2.3790.3959
C:\WINDOWS\system32\SHLWAPI.dll 6.0.3790.4603
C:\WINDOWS\system32\shfolder.dll 6.0.3790.3959
C:\WINDOWS\system32\SHELL32.dll 6.0.3790.4822
C:\WINDOWS\system32\SETUPAPI.dll 5.2.3790.3959
C:\WINDOWS\system32\Secur32.dll 5.2.3790.4530
C:\WINDOWS\system32\scrrun.dll 5.6.0.8832
C:\WINDOWS\system32\rsaenh.dll 5.2.3790.3959
C:\WINDOWS\system32\RPCRT4.dll 5.2.3790.4759
C:\WINDOWS\system32\rasadhlp.dll 5.2.3790.3959
C:\WINDOWS\system32\PSAPI.DLL 5.2.3790.3959
C:\WINDOWS\system32\OLEPRO32.DLL 5.2.3790.3959
C:\WINDOWS\system32\OLEAUT32.dll 5.2.3790.4202
C:\WINDOWS\system32\ole32.dll 5.2.3790.4750
C:\WINDOWS\system32\odbcint.dll 3.526.3959.0
C:\WINDOWS\system32\ODBC32.dll 3.526.4795.0
C:\WINDOWS\system32\ntdll.dll 5.2.3790.4789
C:\WINDOWS\system32\Normaliz.dll 6.0.5441.0
C:\WINDOWS\system32\NETAPI32.dll 5.2.3790.4392
C:\WINDOWS\system32\msxml3.dll 8.100.1051.0
C:\WINDOWS\system32\MSWSOCK.dll 5.2.3790.4318
C:\WINDOWS\system32\msvcrt.dll 7.0.3790.3959
C:\WINDOWS\system32\MSVCP60.dll 7.0.3790.3959
C:\WINDOWS\system32\MSVBVM60.DLL 6.0.97.82
C:\WINDOWS\system32\MSIMG32.dll 5.2.3790.0
C:\WINDOWS\system32\msi.dll 3.1.4000.4042
C:\WINDOWS\system32\msctfime.ime 5.2.3790.3959
C:\WINDOWS\system32\MSCTF.dll 5.2.3790.3959
C:\WINDOWS\system32\mscoree.dll 4.0.31106.0
C:\WINDOWS\system32\mscomctl.ocx 6.0.88.62
C:\WINDOWS\system32\mscomct2.ocx 6.0.88.4
C:\WINDOWS\system32\MFC42.DLL 6.6.8064.0
C:\WINDOWS\system32\kernel32.dll 5.2.3790.4480
C:\WINDOWS\system32\IMM32.DLL 5.2.3790.3959
C:\WINDOWS\system32\iertutil.dll 7.0.6000.17096
C:\WINDOWS\system32\hnetcfg.dll 5.2.3790.3959
C:\WINDOWS\system32\GDI32.dll 5.2.3790.4396
C:\WINDOWS\system32\DNSAPI.dll 5.2.3790.4840
C:\WINDOWS\system32\COMRes.dll 2001.12.4720.3959
C:\WINDOWS\system32\comdlg32.ocx 6.0.81.69
C:\WINDOWS\system32\comdlg32.dll 6.0.3790.3959
C:\WINDOWS\system32\CLBCatQ.DLL 2001.12.4720.3959
C:\WINDOWS\system32\ATL.DLL 3.5.2284.2
C:\WINDOWS\system32\apphelp.dll 5.2.3790.3959
C:\WINDOWS\system32\ADVAPI32.dll 5.2.3790.4455
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\mscoreei.dll 4.0.30319.1
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\MSVCR71.dll 7.10.3052.4
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\mscorwks.dll 1.1.4322.2443
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\mscorsn.dll 1.1.4322.2407
c:\windows\microsoft.net\framework\v1.1.4322\mscorlib.dll 1.1.4322.2443
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\MSCORJIT.DLL 1.1.4322.2443
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\fusion.dll 1.1.4322.2300
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\diasymreader.dll 7.10.3052.4
c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll 1.1.4322.2407
c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.xml.dll 1.1.4322.2371
c:\windows\assembly\gac\system.windows.forms\1.0.5000.0__b77a5c561934e089\system.windows.forms.dll 1.1.4322.2365
c:\windows\assembly\gac\system.drawing\1.0.5000.0__b03f5f7f11d50a3a\system.drawing.dll 1.1.4322.2327
c:\windows\assembly\gac\system.design\1.0.5000.0__b03f5f7f11d50a3a\system.design.dll 1.1.4322.2300
c:\windows\assembly\gac\system.data\1.0.5000.0__b77a5c561934e089\system.data.dll 1.1.4322.2365
c:\windows\assembly\gac\custommarshalers\1.0.5000.0__b03f5f7f11d50a3a\custommarshalers.dll 1.1.4322.573
c:\windows\assembly\gac\accessibility\1.0.5000.0__b03f5f7f11d50a3a\accessibility.dll 1.1.4322.573
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Can you please double check that the jobs you are trying to open were imported with the export file!
and do exists inthe project
There is a chance that you ommited read only objects and they were read only, causing you to have a sequence tat tries to run a job that doesn't exist in the project.

IHTH(I Hope This Helps)
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
kirankumarreddydesireddy
Participant
Posts: 110
Joined: Mon Jan 11, 2010 4:22 am

Post by kirankumarreddydesireddy »

The subsequences which are unable to open from Main sequence exists in the project.I am able to open the subsequences individually.

Do we need to make any changes the DSPARAMS file in the in the project folder,once we take export from Datastage 7.5v and import to Infosphere 8.5v?
Post Reply