I am attempting to run a data job but keep getting the following error:
1: [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied
I enter the oracle ODBC password before this when I set up the job and I could connect fine. Any help would be appreicated.
Post the code you are using to attempt the connection and the full log.
I suspect that your password wasn't passed correctly.
Post the code you are using to attempt the connection and the full log.
I suspect that your password wasn't passed correctly.
I'm using a ODBC data source so no code required. The full log states:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<datafluxdocument class="architectjob" version="1.2">
<jobid id="56E2AD7D389585E9"/>
<propset>
<prop name="_DESCRIPTION">
<value dtype="String"></value>
</prop>
<prop name="_NOTES">
<value dtype="String"></value>
</prop>
<prop name="AutoLayoutRequired"/>
<prop name="DefaultLayout">
<value dtype="String">LeftToRight</value>
</prop>
<prop name="GroupNodes"/>
<prop name="name">
<value dtype="String">Test Data Job</value>
</prop>
<prop name="ShowGridLines">
<value dtype="String">True</value>
</prop>
<prop name="SnapToGrid">
<value dtype="String">False</value>
</prop>
<prop name="STICKYNOTES"/>
<prop name="ZoomLevel">
<value dtype="String">26</value>
</prop>
</propset>
<paramset>
<param name="WFINPUTS" type="matrix"/>
<param name="WFOUTPUTS" type="matrix"/>
</paramset>
<page>
<propset>
<prop name="serial_targets"/>
</propset>
<step id="SOURCE_ODBCSQL" iid="2" ver="1">
<propset>
<prop name="color"/>
<prop name="default_target"/>
<prop name="description">
<value dtype="String">SQL Query 1</value>
</prop>
<prop name="descriptive_text">
<value dtype="String">Specifies an SQL query that selects data from one or more tables. The results table is used as an input in a data job</value>
</prop>
<prop name="node_position">
<value dtype="String">146.4</value>
<value dtype="String">238.761875</value>
</prop>
<prop name="notes">
<value dtype="String"></value>
</prop>
<prop name="serial_target_position"/>
</propset>
<paramset>
<param dtype="String" name="DSN" type="single">DSN=PSELIV01_USER;DFXTYPE=ODBC</param>
<param dtype="Unknown" isnull="true" name="MAX_OUTPUT_ROWS" type="single"></param>
<param dtype="String" name="SQL_STMT" type="single">SELECT GENDER FROM PERSON</param>
<param name="SQL_PARAMETERS" type="matrix"/>
<param dtype="Unknown" isnull="true" name="ROW_ESTIMATE" type="single"></param>
<param dtype="Unknown" isnull="true" name="SQL_PROTOTYPE" type="single"></param>
<param name="TYPE_OVERRIDES" type="matrix"/>
<param dtype="Unknown" isnull="true" name="POOL_NAME" type="single"></param>
</paramset>
</step>
</page>
</datafluxdocument>
Hi,
It appears you are building a data job in Data Management Studio. If you haven't already done so, try going to the "Data" riser on the left in Data Management Studio, right-click on your "PSELIV01_USER" data connection, clear and then save your user credentials.
Ron
Perfect. Many thanks Ron.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.