BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
KPUser
Calcite | Level 5

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.

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

Post the code you are using to attempt the connection and the full log.

 

I suspect that your password wasn't passed correctly.

View solution in original post

4 REPLIES 4
ballardw
Super User

Post the code you are using to attempt the connection and the full log.

 

I suspect that your password wasn't passed correctly.

KPUser
Calcite | Level 5

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>

RonAgresta
SAS Employee

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

KPUser
Calcite | Level 5

Perfect.  Many thanks Ron.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 4 replies
  • 1863 views
  • 1 like
  • 3 in conversation