DataStage SFDC Pack - Experiences and pointers

rkashyap · Post by **rkashyap** » Thu Apr 30, 2015 8:01 pm

We have recently installed SFDC stage/pack (Version 1.5.0.2) with IBM's help.

Some of the things that we have noticed post-installation are:
1. In case of failure in SFDC stage, director log states "No message available"

Message Id: IIS-CONN-DAAPI-00000
Message: Salesforce_6,0: <No message available>

2. No entry was created in Version.xml for SFDC pack.
3. On clicking 'Help' in SFDC stage the message is "Topic not found".
4. On selecting a field from a SFDC table in metedata browser, all the related referenced field are always selected (one has to manually unselect them, which takes multiple clicks).

Are above mentioned things normal for SFDC stage? Please share your experience and pointers regarding SFDC stage.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 30, 2015 9:39 pm

I don't think it's SalesForce per se; it would appear that the resource file that contains error and other messages (for example DS_RESENU for English US) has become inaccessible - or was not installed in the first place.

qt_ky · Post by **qt_ky** » Fri May 01, 2015 5:40 am

I can comment on two of the items, also about salesforce pack 1.5.0.2, but with IS 11.3.1 on AIX.

2. No entry was created in Version.xml for SFDC pack. "CONFIRMED"
- The salesforce pack has its own installer which calls the "dscompinst" program.
- I had also noticed there was no trace of the install in the Version.xml file.
- There are salesforce install logs left under /opt/IBM/InformationServer/Server/eainstlogs
- One of the two log files contains the isadm ID and password logged in plain text!

3. On clicking 'Help' in SFDC stage the message is "Topic not found". "BUSTED"
- When I click 'Help' in the stage, it opens my default browser to a correct location on the IBM Knowledge Center site.

rkashyap · Post by **rkashyap** » Fri May 01, 2015 7:35 pm

Thanks for the information. How is your overall experience with SFDC pack?

Biggest challenge for us in adapting SFDC pack is lack of meaningful error messages. Another issue that we have seen is that the default API version appears to be 27.0 but SFDC is currently at 33.0. We will be discussing these issues with IBM next week.

qt_ky · Post by **qt_ky** » Sun May 03, 2015 7:46 am

Our experience with this stage is just beginning. We have it installed and are currently waiting on credentials in order to use it.

Developer9 · Post by **Developer9** » Wed Oct 28, 2015 10:58 am

Recently we installed Version 1.5 for 11.3 in Unix

While Testing our jobs we found that In Director log ,there is no information about the record counts (for successful runs also)

Code: Select all

SFDC_Test,0: <No message available>

@rkashyap ,

Were you able to figure out the issue while discussing with IBM support ?

Please share us the resolution or findings

Thank you

qt_ky · Post by **qt_ky** » Thu Oct 29, 2015 6:02 am

We have the same version combo installed and running fine. Job log has the usual entries. For the SF Connector, the detailed job log entry looks like this:

Code: Select all

Total number of records retrieved: 10,000
Total number of records retrieved: 20,000
Total number of records retrieved: 30,000
Total number of records retrieved: 40,000
Total number of records retrieved: 50,000
Total number of records retrieved: 60,000
Total number of records retrieved: 62,174

Developer9 · Post by **Developer9** » Thu Oct 29, 2015 7:57 am

In Current version 8.5 ,we selected Batch size "10000"

Below is the log

Code: Select all

SFDC_Test,0: Sent 10,000 records to Salesforce
SFDC_Test,0: Information: Wait for: 30 seconds
SFDC_Test,0: This batch 1 completed
SFDC_Test,0: This batch 2 completed
SFDC_Test,0: Loading finished. 212,233 rows are loaded into Salesforce.com
SFDC_Test,0: Loading finished. 0 rows are rejected

So By default, were you able to see the log for above entries ?or any work around to get ?

Also I observed in Latest version of Pack they have included another tabs "Input/Output " similar to other processing stages.

Can you please share additional information or any documentation related to current pack using
Thank you

chulett · Post by **chulett** » Thu Oct 29, 2015 8:12 am

Seems to me you should be continuing to get IBM's help with this.

qt_ky · Post by **qt_ky** » Thu Oct 29, 2015 11:45 am

It's not the best comparison. It looks like you are sending records to SF, whereas we are only extracting records from SF.

Also if I recall correctly, in the SF Pack download, when you or your admin unzipped everything to install it, there should be a User's Guide PDF in that package. Please look there for the docs.