database host parameter
Hello,
I am importing reports with the IMPORTREPORTNOVALIDATION command. Upon import the database host field is left without the server name. Is there something missing in my SOAP request? alternatively, is there a field in the xml content that I could update with this information?
my SOAP body looks like this.
<soapenv:Envelope xmlns:soapenv=`"http://schemas.xmlsoap.org/soap/envelope/`" xmlns:web=`"http://webservices.web.mi.hof.com/`">
<soapenv:Header/>
<soapenv:Body>
<web:remoteAdministrationCall>
<!--Optional:-->
<arg0>
<loginId>$($YellowFinAdmin)</loginId>
<password>$($YellowFinAdminPass)</password>
<orgId>1</orgId>
<function>IMPORTCONTENTNOVALIDATION</function>
<parameters>$($EncodedText)</parameters>
<parameters>XML</parameters>
<importOption>
<optionIndex>0</optionIndex>
<optionKey>PASSWORD1</optionKey>
<optionValue>$($adfPass)</optionValue>
<optionIndex>1</optionIndex>
<optionKey>PASSWORD2</optionKey>
<optionValue>$($adfPass)</optionValue>
<optionIndex>2</optionIndex>
<optionKey>URL</optionKey>
<optionValue>$($sqlServerName).database.windows.net</optionValue>
</importOption>
</arg0>
</web:remoteAdministrationCall>
</soapenv:Body>
</soapenv:Envelope>
The same question
Hi Austin,
Looking at your SOAP request it appears to be correct. Can you run a test with a full hardcoded url including the server name to see if this passes through correctly? I just want to see if there is an issue with the yellowfin processing the input or if there may be an issue with the $sqlServerName coming in correctly? Can you also upload your log files to ftp.yellowfin.bi after running this import (both a hardcoded and a $sqlServerName parameter version) so I can see what details yellowfin is taking in?
Cheers,
Neal
Hi Austin,
Looking at your SOAP request it appears to be correct. Can you run a test with a full hardcoded url including the server name to see if this passes through correctly? I just want to see if there is an issue with the yellowfin processing the input or if there may be an issue with the $sqlServerName coming in correctly? Can you also upload your log files to ftp.yellowfin.bi after running this import (both a hardcoded and a $sqlServerName parameter version) so I can see what details yellowfin is taking in?
Cheers,
Neal
Hi Austin,
To try and better diagnose the connection failure, can you please send me your logs (catalina, source, jdbc and yellowfin) please from /yfinstall/appserver/logs and I will see if there is anything obvious in there. Before sending these through, can you try to test the connection and note down the time of this so I can narrow my focus to this.
As for the access filter, does this update correctly but the export does not look correct? Or does this not work as expected? If it is the later, let me know the time of day it is set to update the list and I can have a look in the logs for any errors present.
Cheers,
Neal
Hi Austin,
To try and better diagnose the connection failure, can you please send me your logs (catalina, source, jdbc and yellowfin) please from /yfinstall/appserver/logs and I will see if there is anything obvious in there. Before sending these through, can you try to test the connection and note down the time of this so I can narrow my focus to this.
As for the access filter, does this update correctly but the export does not look correct? Or does this not work as expected? If it is the later, let me know the time of day it is set to update the list and I can have a look in the logs for any errors present.
Cheers,
Neal
Hi Austin,
Hope you are well. I am following up on this issue to see if you have been able to resolve this issue? If not, could you please provide your log files so we can further diagnose this.
Cheers,
Neal
Hi Austin,
Hope you are well. I am following up on this issue to see if you have been able to resolve this issue? If not, could you please provide your log files so we can further diagnose this.
Cheers,
Neal
Hi Austin,
I hope things are going well over there.
Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.
Cheers,
Neal
Hi Austin,
I hope things are going well over there.
Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.
Cheers,
Neal
Replies have been locked on this page!