SAP InfoSpoke

JohnSLF · Post by **JohnSLF** » Tue Feb 20, 2007 2:15 pm

Is anyone pulling data from SAP using InfoSpokes? My jobs timeout while attempting to access an InfoSpoke that contains either a date or a time field. When the date and/or time field is removed from the InfoSpoke, the job runs successfully.

JohnSLF · Post by **JohnSLF** » Fri Feb 23, 2007 8:23 am

It appears SAP has an issue with the DB table created when an Infospoke is established. The DB table is set with the required fields during the initial setup of the Infospoke, but any subsequent changes to the Infospoke are not presented to the DB table (the DB table is not refreshed). I think this difference in SAP between the Infospoke and the DB table causes my Datastage job to time-out. If you create a new Infospoke with a slight change in the name (within the first 10 characters) and adjust your Datastage job to access the new Infospoke, the job will execute properly.
As for the date problem, SAP is sending a date without the "-" between the year, month and day. Datastage is expecting the "-", and fails. Change the date type to VarChar in Datastage and insert the "-" in the first Transfomer stage.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 23, 2007 3:37 pm

Thank you for that valuable information.

You can read the date column by changing its Format String property to "%yyyy%mm%dd" (with no delimiter characters); thereby avoiding the data type conversion.