About former_member316405

former_member316405

Hi all,I need to extract xml data from a field in a table to an xml file. The table has fields like TransactionID varchar(15),Request_XML varchar(max)/XML datatype .Could you please let me know what are the different approaches we have in SAP BODS to...

former_member316405

Hi All,I'm getting error "Function not found in the repository" when I use extract_from_xml function in a job in SAP BODS 4.2 SP06. I'm unable to see the function in Conversion category or anywhere using function wizard but I can see it when I type i...

former_member316405

Hi All,I've installed SAP BODS in Host A for Development environment and in Host B for Testing environment. Both the hosts are of Windows Server 2012 operating systems. I need to migrate my code from Dev Central from Host A to Test repo in Host B. I ...

former_member316405

former_member316405

Hi Experts,I'm kind of new to SAP BW. I made changes to a Transform in my development system and the changes are working well in Development.But when I'm trying to move the transform to Testing system the transport is failing with returned code 12.I ...

former_member316405

Create a file location object under file format tab with all the details of SFTP server. Give the file location object name in copy_from_remote_system function enclosed in single quotes. Thanks,Niranjan

former_member316405

Hi Bhave,I've generated SSH-1 RSA public key. But BODS gives the error"Could not authenticate SSH session for file location object<xxxxx> .Error(-19) Invalid public key,too short." I've used the generated bit code as 2048/5120Please help me with thi...

former_member316405

Hi Ivan,Just remove the target file object from the dataflow and then drag and drop and connect.Then select the filelocation object in the target file and save the changes and run the job.Your job should run successfully now.Thanks,Niranjan

former_member316405

The issue was resolved after adding the hostname in inthe hostname file in etc folder.

former_member316405

Try giving the system name as VANDEVVMWIN007:6400 and give the ip address and the port number 6400 if that doesn't work.

User Statistics

User Activity

How to extract XML data from a field in a table?

Function not found in repository in SAP BODS 4.2SP06

How to connect DEV SAP BODS and Test SAP BODS environments?

Need help generating XML from a table

Transport of a Transform failed with returned code 12

Re: BODS- Move file from SFTP to local

Re: Unable to connect to an SFTP server using Dataservices File Location Object

Re: Error when using File Location SFTP, XML target and file name in global variable

Re: How to connect DEV SAP BODS and Test SAP BODS environments?

Re: Login Error: FWM 20030