26 Replies Latest reply: Apr 17, 2012 4:41 PM by Stephen Millard RSS

OrgChart Extraction Process

Raffaello Sanzio Rodiman
Currently Being Moderated

Hi Expert,

 

I would to know in our OrgChart Sp2.0 extraction process i have listed:

 

The command example is:

sh <<path to sapextractor.sh>> /sapextractor.sh /sapmnt/<<SERVER_NAME>>

/exe/jvm/linuxx86_64/sapjvm_5.1.024/sapjvm_5/bin /usr/sap/<<SERVER_NAME>>

/J00/j2ee/cluster/apps/Nakisa/ <<build_name>>/servlet_jsp/<<build_name>>/root

___000___SAP_Sql /sapmnt/ <<SERVER_NAME>>

/exe/jvm/linuxx86_64/sapjvm_5.1.024/sapjvm_5/jre/lib/amd64/server/sapjco.jar

NakisaFrameworkBin061032100 NakisaTrollBin061032100 true true true

 

All the information I listed is:

Executeable:

/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root

Java SDK

/opt/IBMJava2-amd64-142

Nakisa Extract

/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001

Build Name

__000__DHS_STAGED_001

SAPJVM

/sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin

Sapjco (downloaded manualy and put the files there)

/sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco.jar

 

I just confused with the guide mentioned on NakisaFrameworkBinxx.jar and NakisaTrolBinxx.jar file

As on our /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/WEB-INF/lib/ there is only NakisaFrameworkBin.jar & NakisaTrollBin.jar.

 

But the guide said its like NakisaFrameworkBin061032100 NakisaTrollBin061032100

 

How do I identified the build number for this ?

 

Cheers,

Raff

  • Re: OrgChart Extraction Process
    Stephen Millard
    Currently Being Moderated

    Raff.

     

    If you actually take a peak inside the sapextractor.sh file you can see what it's trying to do with these parameters.  It's looking for a couple of jar files based on your OrgChart installation path.

     

    Take a look in

    /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/WEB-INF/lib/

     

    I'm guessing you'll see two files in here something like this...

    • NakisaFrameworkBin.jar
    • NakisaTrollBin.jar

     

    Assuming you do, you should just need to pass in the names of these files excluding the extension (as this is appended on by the script).

    e.g. "NakisaFrameworkBin" and "NakisaTrollBin".

     

    Hope that helps

     

    Stephen.

    • Re: OrgChart Extraction Process
      Raffaello Sanzio Rodiman
      Currently Being Moderated

      Hi Stephen,

       

      Thanks for your assist on this.

       

      I manage to execute with below command:

      sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true

       

      And its throwing me this error:

      Exception in thread "main" java.lang.NoClassDefFoundError: com/nakisa/sap/extractor/commandline/SAPExtractorCommandLine
      Caused by: java.lang.ClassNotFoundException: com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine
              at java.net.URLClassLoader$1.run(URLClassLoader.java:261)
              at java.security.AccessController.doPrivileged(Native Method)
              at java.net.URLClassLoader.findClass(URLClassLoader.java:249)
              at java.lang.ClassLoader.loadClass(ClassLoader.java:362)
              at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:319)
              at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
              at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:375)
      • Re: OrgChart Extraction Process
        Stephen Millard
        Currently Being Moderated

        The path to the OrgChart application looks to be pointing a few levels too deep.  you want to be pointing to the deployment path of the application not to your Admin_Config directory.  So I think you need to remove "/.system/Admin_Config/"

         

        I think you've also missed a space out before the build name meaning that your 2nd parameter is a bit more wrong and your subsequent parameters are then either out of step or missing.

  • Re: OrgChart Extraction Process
    Raffaello Sanzio Rodiman
    Currently Being Moderated

    Passing .jar on the Framework and NakisaTrollBin resulted the same error.

     

    sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin.jar NakisaTrollBin.jar true true true
    Exception in thread "main" java.lang.NoClassDefFoundError: com/nakisa/sap/extractor/commandline/SAPExtractorCommandLine
    Caused by: java.lang.ClassNotFoundException: com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine
            at java.net.URLClassLoader$1.run(URLClassLoader.java:261)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(URLClassLoader.java:249)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:362)
            at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:319)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
            at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:375)

     

    Cheers,

    Raff

  • Re: OrgChart Extraction Process
    Raffaello Sanzio Rodiman
    Currently Being Moderated

    Hi Both,

     

    Really appreciate for your assist:

    The command quite confusing as I tought the its point to the __000__DHS_STAGED_001 directory.

     

    I manage to use below command:

    sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/ __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true

     

    And the here's the outcome: (are this correct ?)

    -ap[length:3]
    033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//[length:81]
    -b[length:2]
    __000__DHS_STAGED_001[length:21]
    -e[length:2]
    true[length:4]
    -j[length:2]
    true[length:4]
    -a[length:2]
    true[length:4]
    [length:1]
    Using build path: __000__DHS_STAGED_001
    Extract: true
    Generating Analytics: true
    Using joins: true
    Loading Manager Resources:
    /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/ManagerResources.xml
    Loading Manager Resources:
    /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/__000__DHS_STAGED_001/ManagerResources.xml
    Loading App Resources:
    /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/__000__DHS_STAGED_001/AppResources
    Loading Counts:
    /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/__000__DHS_STAGED_001/Analytics/Counts.xml
    Loading Extractor Configuration:
    /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/__000__DHS_STAGED_001/SAPExtractor/extractorSchema
    Extracting...
    Exception in thread "main" java.lang.NoClassDefFoundError: com/sap/mw/jco/IRepository
            at com.nakisa.framework.data.commandProcessor.impl.sap.BaseFunctionProcessor.call(BaseFunctionProcessor.java:86)
            at Nakisa.SAP.SAPeProcessor.RfcReadTable.getDataSet(RfcReadTable.java:47)
            at com.nakisa.framework.data.commandProcessor.impl.sap.BaseFunctionProcessor.getDataSetFinal(BaseFunctionProcessor.java:103)
            at com.nakisa.framework.data.commandProcessor.impl.sap.SAPCommandProcessor.getDataSet(SAPCommandProcessor.java:42)
            at com.nakisa.framework.data.commandProcessor.CommandProcessor.getDataSet(CommandProcessor.java:369)
            at com.nakisa.framework.data.DataAccess.getDataSet(DataAccess.java:26)
            at com.nakisa.sap.extractor.SAPExtractorProcessor.processSimpleFunction(SAPExtractorProcessor.java:1303)
            at com.nakisa.sap.extractor.SAPExtractorProcessor.processSimpleFunctionAt(SAPExtractorProcessor.java:716)
            at com.nakisa.sap.extractor.SAPExtractorProcessor.parseFunctionSchema(SAPExtractorProcessor.java:852)
            at com.nakisa.sap.extractor.SAPExtractorProcessor.extract(SAPExtractorProcessor.java:519)
            at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.startExtractionProcess(SAPExtractorCommandLine.java:141)
            at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.startExtraction(SAPExtractorCommandLine.java:112)
            at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.<init>(SAPExtractorCommandLine.java:103)
            at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.main(SAPExtractorCommandLine.java:70)
    Caused by: java.lang.ClassNotFoundException: com.sap.mw.jco.IRepository
            at java.net.URLClassLoader$1.run(URLClassLoader.java:261)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(URLClassLoader.java:249)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:362)
            at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:319)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
            at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:375)
            ... 14 more

     

    Cheers,

    Raff

    • Re: OrgChart Extraction Process
      Luke Marson
      Currently Being Moderated

      Hi Raff,

       

      It looks like you are using SAP JCo 3, but the extractor uses SAP JCo 2.1.8 or 2.1.10. See the Admin Guide page 54.

       

      Best regards,

       

      Luke

      • Re: OrgChart Extraction Process
        Raffaello Sanzio Rodiman
        Currently Being Moderated

        Hi Luke,

         

        My Bad, my admin guide is for Nakisa 3.0 SP1

        I will download JC) 2.1.10 and will let you know.

         

        Cheers,

        Raff

      • Re: OrgChart Extraction Process
        Raffaello Sanzio Rodiman
        Currently Being Moderated

        Hi Luke,

         

        I saw some fatal error premature when the scripts run.

        Its looks done now, are this sign of good news ?

         

        sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco.jar NakisaFrameworkBin NakisaTrollBin true true true

         

        -ap[length:3]
        033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/[length:80]
        -b[length:2]
        __000__DHS_STAGED_001[length:21]
        -e[length:2]
        true[length:4]
        -j[length:2]
        true[length:4]
        -a[length:2]
        true[length:4]
        [length:1]
        [Fatal Error] :-1:-1: Premature end of file.
        [Fatal Error] :-1:-1: Premature end of file.
        Using build path: __000__DHS_STAGED_001
        Extract: true
        Generating Analytics: true
        Using joins: true
        Loading Manager Resources:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/ManagerResources.xml
        Loading Manager Resources:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/ManagerResources.xml
        Loading App Resources:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/AppResources
        Loading Counts:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/Analytics/Counts.xml
        Loading Extractor Configuration:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/SAPExtractor/extractorSchema
        Extracting...
        Done extracting.
        Joining tables...
        Done joining tables.
        Executing analytics...
        Admin_Analytics_Generating: PersonFTE ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: TotalPersonFTE ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: PositionFTE ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: TotalPositionFTE ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: Gender ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: GenderDisab ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: Nationality ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: Disab ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: Age ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: Race ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: Ethen ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: UnOcPosCount ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: OcPosCount ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: UnOcVacPosCount ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: OcVacPosCount ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: PersonFTEPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: PositionFTEPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: GenderCounterPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: GenderDisabCountPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: NationalityPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: DisabPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: AgePos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: RacePos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: EthenPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: UnOcPosCountPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: OcPosCountPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: UnOcVacPosCountPos ...
        Admin_Analytics_Generate_Success
        Admin_Analytics_Generating: OcVacPosCountPos ...
        Admin_Analytics_Generate_Success
        Done executing analytics.
        • Re: OrgChart Extraction Process
          Luke Marson
          Currently Being Moderated

          Hi Raff,

           

          Everything looks fine to me, despite the errors. The next thing is to check the database and the application to make sure it did actually work, but everything seems to point to that from the messagesyou received. However, I would still like to check that error message.

           

          Best regards,

           

          Luke

        • Re: OrgChart Extraction Process
          Stephen Millard
          Currently Being Moderated

          That looks good.  Check the database and the cds.log to see what information it has in it.

           

          You should see information about extract row counts, joins being completed, tables dropped and created and analytics being generated.

           

          If you see errors that don't relate to dropping non-existent objects then you've still got issues.

           

          You should also be able to see your data in OrgChart!

          • Re: OrgChart Extraction Process
            Raffaello Sanzio Rodiman
            Currently Being Moderated

            Hi Stephen,

             

            This is what I've got from the log.

            Hope it looks good

            13 Apr 2012 10:46:54 INFO  com.nakisa.Logger  - [Admin console] admin user 'admin' successfully logged in
            13 Apr 2012 10:47:10 INFO  com.nakisa.Logger  - ManagerInit: Time took to setup Build: 7199 ms
            13 Apr 2012 10:47:12 INFO  com.nakisa.Logger  - ManagerInit: Time took to load settingsResources: 115 ms
            13 Apr 2012 10:47:15 INFO  com.nakisa.Logger  - ManagerInit: Time took to load appResources: 1072 ms
            13 Apr 2012 10:47:15 INFO  com.nakisa.Logger  - ManagerInit: Time took to load extractorSchema: 67 ms
            13 Apr 2012 10:47:15 INFO  com.nakisa.Logger  - ManagerInit: Time took to load OTFSchema: 120 ms
            13 Apr 2012 10:47:15 INFO  com.nakisa.Logger  - ManagerInit: Time took to load Role Mapping: 2 ms
            13 Apr 2012 10:47:15 INFO  com.nakisa.Logger  - ManagerInit: Time took to load Roles: 2 ms
            13 Apr 2012 11:55:25 INFO  com.nakisa.Logger  - ManagerSave: Time took to save AppResources: 7494 ms
            13 Apr 2012 11:55:27 INFO  com.nakisa.Logger  - ManagerSave: Time took to save Roles and RoleMapping: 43 ms
            13 Apr 2012 11:55:27 INFO  com.nakisa.Logger  - ManagerSave: Time took to save LanguageDB: 52 ms
            13 Apr 2012 11:55:27 INFO  com.nakisa.Logger  - ManagerSave: Time took to save ExtractorSchema: 159 ms
            13 Apr 2012 11:55:27 INFO  com.nakisa.Logger  - ManagerSave: Time took to save OTFSchema: 122 ms
            13 Apr 2012 11:55:29 INFO  com.nakisa.Logger  - ManagerPublish: Time took to move Tenant Deltas: 226 ms
            13 Apr 2012 11:55:30 INFO  com.nakisa.Logger  - ManagerPublish: Time took to move Configs: 94 ms
            13 Apr 2012 11:55:31 INFO  com.nakisa.Logger  - LoginSettingsObject Load: 8
            13 Apr 2012 11:55:31 INFO  com.nakisa.Logger  - Refresh in-memory configurations: 135
            13 Apr 2012 11:55:35 INFO  com.nakisa.Logger  - AppResources Load: 3001
            13 Apr 2012 12:03:18 INFO  com.nakisa.Logger  - [Admin console] - logging out user : admin
            13 Apr 2012 14:10:24 INFO  com.nakisa.Logger  - [Admin console] admin user 'admin' successfully logged in
            13 Apr 2012 14:10:30 INFO  com.nakisa.Logger  - ManagerInit: Time took to setup Build: 786 ms
            13 Apr 2012 14:10:31 INFO  com.nakisa.Logger  - ManagerInit: Time took to load settingsResources: 173 ms
            13 Apr 2012 14:10:34 INFO  com.nakisa.Logger  - ManagerInit: Time took to load appResources: 1251 ms
            13 Apr 2012 14:10:34 INFO  com.nakisa.Logger  - ManagerInit: Time took to load extractorSchema: 107 ms
            13 Apr 2012 14:10:34 INFO  com.nakisa.Logger  - ManagerInit: Time took to load OTFSchema: 121 ms
            13 Apr 2012 14:10:34 INFO  com.nakisa.Logger  - ManagerInit: Time took to load Role Mapping: 2 ms
            13 Apr 2012 14:10:34 INFO  com.nakisa.Logger  - ManagerInit: Time took to load Roles: 2 ms
            13 Apr 2012 15:59:28 INFO  com.nakisa.Logger  - [Admin console] - logging out user : admin
            13 Apr 2012 16:15:53 INFO  com.nakisa.Logger  - [Admin console] admin user 'admin' successfully logged in
            13 Apr 2012 16:16:02 INFO  com.nakisa.Logger  - ManagerInit: Time took to setup Build: 1169 ms
            13 Apr 2012 16:16:04 INFO  com.nakisa.Logger  - ManagerInit: Time took to load settingsResources: 114 ms
            13 Apr 2012 16:16:06 INFO  com.nakisa.Logger  - ManagerInit: Time took to load appResources: 918 ms
            13 Apr 2012 16:16:07 INFO  com.nakisa.Logger  - ManagerInit: Time took to load extractorSchema: 49 ms
            13 Apr 2012 16:16:07 INFO  com.nakisa.Logger  - ManagerInit: Time took to load OTFSchema: 119 ms
            13 Apr 2012 16:16:07 INFO  com.nakisa.Logger  - ManagerInit: Time took to load Role Mapping: 2 ms
            13 Apr 2012 16:16:07 INFO  com.nakisa.Logger  - ManagerInit: Time took to load Roles: 2 ms
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - -ap: size=3
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - 033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//: size=81
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - -b: size=2
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - __000__DHS_STAGED_001: size=21
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - -e: size=2
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - true: size=4
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - -j: size=2
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - true: size=4
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - -a: size=2
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - true: size=4
            : size=1012 17:08:57 INFO  com.nakisa.Logger  -
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - <item><name><![CDATA[ap]]></name><value><![CDATA[033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//]]></value></item><
            item><name><![CDATA[b]]></name><value><![CDATA[__000__DHS_STAGED_001]]></value></item><item><name><![CDATA[e]]></name><value><![CDATA[true]]></value></item><item><name><![CDATA[j]]></name><value><!
            [CDATA[true]]></value></item><item><name><![CDATA[a]]></name><value><![CDATA[true]]></value></item>
            13 Apr 2012 17:08:57 INFO  com.nakisa.Logger  - [Admin console] admin user 'admin' successfully logged in
            13 Apr 2012 17:09:14 INFO  com.nakisa.Logger  - SAP Extractor : nullRfcReadTable(Read Table Function/BAPI).nullObjid, Stabs
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - -ap: size=3
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - 033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/: size=80
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - -b: size=2
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - __000__DHS_STAGED_001: size=21
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - -e: size=2
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - true: size=4
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - -j: size=2
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - true: size=4
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - -a: size=2
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - true: size=4
            : size=1012 17:15:27 INFO  com.nakisa.Logger  -
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - <item><name><![CDATA[ap]]></name><value><![CDATA[033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/]]></value></item><i
            tem><name><![CDATA[b]]></name><value><![CDATA[__000__DHS_STAGED_001]]></value></item><item><name><![CDATA[e]]></name><value><![CDATA[true]]></value></item><item><name><![CDATA[j]]></name><value><![
            CDATA[true]]></value></item><item><name><![CDATA[a]]></name><value><![CDATA[true]]></value></item>
            13 Apr 2012 17:15:27 INFO  com.nakisa.Logger  - [Admin console] admin user 'admin' successfully logged in
            13 Apr 2012 17:15:43 INFO  com.nakisa.Logger  - SAP Extractor : nullRfcReadTable(Read Table Function/BAPI).nullObjid, Stabs
  • Re: OrgChart Extraction Process
    Raffaello Sanzio Rodiman
    Currently Being Moderated

    Hi Both,

     

    Thanks for assisting me on this today.

     

    The conclusion is:

    • Nakisa 3.0 SP2
    • Use Jco 2.1.10
    • and dont point to /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001 directory instead /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/ __000__DHS_STAGED_001
    • dont put .jar on NakisaFrameworkBin & NakisaTrollBin

     

    This is the example command:

    sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco.jar NakisaFrameworkBin NakisaTrollBin true true true

     

     

    Cheers,

    Raff

    • Re: OrgChart Extraction Process
      Luke Marson
      Currently Being Moderated

      Hi Raff,

       

      Try running this command:

       

      sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /usr/sap/NKD/J30/j2ee/JSPM/sapjvm/jre/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true

       

      Best regards,

       

      Luke

      • Re: OrgChart Extraction Process
        Raffaello Sanzio Rodiman
        Currently Being Moderated

        Hi Luke,

         

        I've just deleted the sapjco3.jar from the /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/

         

        Should I put it back ?

      • Re: OrgChart Extraction Process
        Raffaello Sanzio Rodiman
        Currently Being Moderated

        Since I curious, I put back sapjco3

         

        And its seems like pointing to JSPM isn't work too, throwing the same error.

        dhssps:nkdadm 271> sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /usr/sap/NKD/J30/j2ee/JSPM/sapjvm/jre/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true
        -ap[length:3]
        033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/[length:80]
        -b[length:2]
        __000__DHS_STAGED_001[length:21]
        -e[length:2]
        true[length:4]
        -j[length:2]
        true[length:4]
        -a[length:2]
        true[length:4]
        [length:1]
        [Fatal Error] :-1:-1: Premature end of file.
        [Fatal Error] :-1:-1: Premature end of file.
        Using build path: __000__DHS_STAGED_001
        Extract: true
        Generating Analytics: true
        Using joins: true
        Loading Manager Resources:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/ManagerResources.xml
        Loading Manager Resources:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/ManagerResources.xml
        Loading App Resources:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/AppResources
        Loading Counts:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/Analytics/Counts.xml
        Loading Extractor Configuration:
        /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/SAPExtractor/extractorSchema
        Extracting...
        Exception in thread "main" java.lang.NoClassDefFoundError: com/sap/mw/jco/IRepository
                at com.nakisa.framework.data.commandProcessor.impl.sap.BaseFunctionProcessor.call(BaseFunctionProcessor.java:86)
                at Nakisa.SAP.SAPeProcessor.RfcReadTable.getDataSet(RfcReadTable.java:47)
                at com.nakisa.framework.data.commandProcessor.impl.sap.BaseFunctionProcessor.getDataSetFinal(BaseFunctionProcessor.java:103)
                at com.nakisa.framework.data.commandProcessor.impl.sap.SAPCommandProcessor.getDataSet(SAPCommandProcessor.java:42)
                at com.nakisa.framework.data.commandProcessor.CommandProcessor.getDataSet(CommandProcessor.java:369)
                at com.nakisa.framework.data.DataAccess.getDataSet(DataAccess.java:26)
                at com.nakisa.sap.extractor.SAPExtractorProcessor.processSimpleFunction(SAPExtractorProcessor.java:1303)
                at com.nakisa.sap.extractor.SAPExtractorProcessor.processSimpleFunctionAt(SAPExtractorProcessor.java:716)
                at com.nakisa.sap.extractor.SAPExtractorProcessor.parseFunctionSchema(SAPExtractorProcessor.java:852)
                at com.nakisa.sap.extractor.SAPExtractorProcessor.extract(SAPExtractorProcessor.java:519)
                at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.startExtractionProcess(SAPExtractorCommandLine.java:141)
                at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.startExtraction(SAPExtractorCommandLine.java:112)
                at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.<init>(SAPExtractorCommandLine.java:103)
                at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.main(SAPExtractorCommandLine.java:70)
        Caused by: java.lang.ClassNotFoundException: com.sap.mw.jco.IRepository
                at java.net.URLClassLoader$1.run(URLClassLoader.java:261)
                at java.security.AccessController.doPrivileged(Native Method)
                at java.net.URLClassLoader.findClass(URLClassLoader.java:249)
                at java.lang.ClassLoader.loadClass(ClassLoader.java:362)
                at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:319)
                at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
                at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:375)
                ... 14 more

         

        Cheers,

        Raff

        • Re: OrgChart Extraction Process
          Luke Marson
          Currently Being Moderated

          At another client we use the JSPM jvm as the 2nd parameter. SAP JCo 3 won't work so the statement will definitely error if you use it.

        • Re: OrgChart Extraction Process
          Stephen Millard
          Currently Being Moderated

          Sorry - I managed to miss that entire "premature end of file" notification ... I'm jumping around trying to wrap up things for the day.

           

          That is a bad sign and the output in the cds.log looks rather limited too.  I assume you don't have any data in the database.

           

          I'm not 1005 on how I'm reading the output, but it looks like it is reporting the length of each parameter as it is being read in.  So the command that actually gets executed is..

           

          $1/java -Xmx1g -classpath "{lots of JAR file paths in here}" com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine -ap \033$2/ -b $3 -e $7 -j $8 -a $9

           

          Now line 2 you can see corresponds to the "-ap" in the line above ... which is three characters long.

          So on through to the "trye" pass in for the -a (analytics).

          After that it reads in a further parameter of length 1 ... which I think is a space at the end of the command from sapextractor.sh.

           

          So at this point I think (and this is a big assumptive "think") Java tries to load all the JAR files in.  Now a premature end of file isn't the same as not found, and so I think does lend further credence to Luke's observation about the SAP JCo version.

           

          Should you still get the same issue after resolving the SAP JCo version I'd suggest going through the list of JAR files and just confirming they are all in place.

  • Re: OrgChart Extraction Process
    Raffaello Sanzio Rodiman
    Currently Being Moderated

    Hi Both,

     

    I have analyze the error and check on the scripts itself.

     

    Basically the scripts will execute below parameter:

    #!/bin/sh
    # $1 Path to the java sdk
    # $2 Path to the deployed Nakisa OrgChart application
    # $3 Build name (must match the build name displayed in the AdminConsole)
    # $4 Path to the SAP java connector file (sapjco.jar)
    # $5 Name of the NakisaFrameworkBinxx.jar file, where xx is the build number. Find this file in the [application directory]/WEB-INF/lib directory to get the build number.
    # $6 Name of the NakisaTrolBinxx.jar file, where xx is the build number. Find this file in the [application directory]/WEB-INF/lib directory to get the build number
    # $7 Extract data (options: true|false)
    # $8 Execute joins on extracted data (options: true|false)
    # $9 Generate analytics (options: true|false)

     

    From the error below I can indicate something missing or not grabbed correcly as per Stephen Advised.

    -ap[length:3]
    033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/[length:80]
    -b[length:2]
    __000__DHS_STAGED_001[length:21]
    -e[length:2]
    true[length:4]
    -j[length:2]
    true[length:4]
    -a[length:2]
    true[length:4]
    [length:1]
    [Fatal Error] :-1:-1: Premature end of file.
    [Fatal Error] :-1:-1: Premature end of file.
    Using build path: __000__DHS_STAGED_001
    Extract: true
    Generating Analytics: true
    Using joins: true

     

    I have checked all the scripts and mark it with * that the lib is there, so I can say, there is nothing wrong with the library as all is there:

    $1/java -Xmx1g -classpath ".:
    $4:
    *$2/WEB-INF/lib/SAPExtractorCommandLine.jar:
    *$2/WEB-INF/lib/db2jcc.jar:
    *$2/WEB-INF/lib/db2jcc_license_cu.jar:
    *$2/WEB-INF/lib/commons-beanutils.jar:
    *$2/WEB-INF/lib/commons-codec-1.3.jar:
    *$2/WEB-INF/lib/commons-collections.jar:
    *$2/WEB-INF/lib/commons-dbcp.jar:
    *$2/WEB-INF/lib/commons-digester-1.8.jar:
    *$2/WEB-INF/lib/commons-fileupload.jar:
    *$2/WEB-INF/lib/commons-io.jar:
    *$2/WEB-INF/lib/commons-jelly-1.0.jar:
    *$2/WEB-INF/lib/commons-jexl-1.0.jar:
    *$2/WEB-INF/lib/commons-jxpath-1.2.jar:
    *$2/WEB-INF/lib/commons-lang.jar:
    *$2/WEB-INF/lib/commons-logging.jar:
    *$2/WEB-INF/lib/commons-pool.jar:
    *$2/WEB-INF/lib/core-renderer.jar:
    *$2/WEB-INF/lib/dom4j-1.5.2.jar:
    *$2/WEB-INF/lib/el-impl-1.0.jar:
    *$2/WEB-INF/lib/$5.jar:
    *$2/WEB-INF/lib/jsf-api.jar:
    *$2/WEB-INF/lib/jsf-facelets.jar:
    *$2/WEB-INF/lib/jsf-impl.jar:
    *$2/WEB-INF/lib/ldapbp.jar:
    *$2/WEB-INF/lib/log4j-1.2.15.jar:
    *$2/WEB-INF/lib/ojdbc5_g.jar:
    *$2/WEB-INF/lib/pd4ml.jar:
    *$2/WEB-INF/lib/sapdbc.jar:
    *$2/WEB-INF/lib/serializer.jar:
    *$2/WEB-INF/lib/spring-ldap-1.2.jar:
    *$2/WEB-INF/lib/spring.jar:
    *$2/WEB-INF/lib/sqljdbc.jar:
    *$2/WEB-INF/lib/ss_css2.jar:
    *$2/WEB-INF/lib/trinidad-api-1.2.11.jar:
    *$2/WEB-INF/lib/trinidad-impl-1.2.11.jar:
    *$2/WEB-INF/lib/$6.jar:
    *$2/WEB-INF/lib/webrendererse.jar:
    *$2/WEB-INF/lib/xalan.jar:
    *$2/WEB-INF/lib/xercesImpl.jar: 
    *$2/WEB-INF/lib/xml-apis.jar" com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine -ap \033$2/ -
    b $3 -e $7 -j $8 -a $9

     

    After check on the database, and we do some test to remove the DB and SYNC back the data is populated.

     

    Cheers,

    Raff

    • Re: OrgChart Extraction Process
      Stephen Millard
      Currently Being Moderated

      Raff.

       

      If you cleared the tables and they've re-populated, that's a good sign ....

       

      That being said, those premature end of file messages are still appearing so I can't say in good conscience that you can trust the set of results being returned.  The results could be correct - but error messages are there for a reason after all and they may not always be correct.

       

      I did a quick search on this premature end of file error and there is another discussion from last September where someone else had the same error message (along with quite a few others by the sounds of it).  I would suggest that you have a read through the whole thread to make sense of it and then review the actions undertaken in the last post on the thread.  It looks like they were on SP1, but at this point it is worth a try and should that fail, then I think your best option (as per Luke's suggestions above) would be to get yourself onto the latest build (though SP3 did became available today) and failing that raise an OSS message for the error.

       

       

      Stephen.

Actions