Page 1 of 1

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

Posted: Thu Jul 21, 2011 4:55 am
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

Posted: Thu Jul 21, 2011 8:36 am
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)

Posted: Thu Jul 21, 2011 11:58 pm
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?