Error in Information Map Studio while testing

deleted_user — Wed, 20 Jun 2007 12:50:04 GMT

Hi Guys

I get this error when I try to test the information through Information Map Studio.

Exception occurred while attempting to access data.

com.sas.iquery.dataretrieval.DataRetrievalException: Exception occurred while attempting to access data. [ com.sas.iquery.dataretrieval.DataRetrievalException: Exception occurred when retrieving the ResultSet. [ com.sas.iquery.dataretrieval.DataRetrievalException: Unable to execute query. [ com.sas.iquery.execution2.ExecutionException: /* =================================== */
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to The BSS Group plc, Site 0098682001.
NOTE: This session is executing on the AIX 5.3 platform.

NOTE: SAS 9.1.3 Service Pack 4

You are running SAS 9. Some SAS 8 files will be automatically converted
by the V9 engine; others are incompatible. Please see
http://support.sas.com/rnd/migration/planning/platform/64bit.html

PROC MIGRATE will preserve current SAS file attributes and is
recommended for converting all your SAS libraries from any
SAS 8 release to SAS 9. For details and examples, please see
http://support.sas.com/rnd/migration/index.html

This message is contained in the SAS news file, and is presented upon
initialization. Edit the file "news" in the "misc/base" directory to
display site-specific news and information in the program log.
The command line option "-nonews" will prevent this display.

NOTE: SAS Initialization used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

1 options Locale=en_GB;
1 The SAS System 13:51 Wednesday, June 20, 2007

2 LIBNAME DEVX ORACLE PATH=DEVX SCHEMA=DEVE ;
ERROR: ORACLE connection error: ORA-01017: invalid username/password; logon denied.
ERROR: Error in the LIBNAME statement.
3
2 The SAS System 13:51 Wednesday, June 20, 2007

4 Proc SQL;
4 ! Create Table A7 as
5 SELECT
6 table0.SH_SO_ACCOUNT AS DIR_2 LABEL='Sh_So_Account' FORMAT=$8.
7 FROM
8 DEVX.SH_02_SALES table0
9 ;
ERROR: Libname DEVX is not assigned.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
10 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

11

Exception occurred while executing query. (select * from A7)
Unable to execute query: com.sas.iom.SASIOMDefs.GenericError: SQL passthru expression contained these errors: ERROR: File WORK.A7.DATA does not exist.... [ java.sql.SQLException: Unable to execute query: com.sas.iom.SASIOMDefs.GenericError: SQL passthru expression contained these errors: ERROR: File WORK.A7.DATA does not exist.... [ java.sql.SQLException: com.sas.iom.SASIOMDefs.GenericError: SQL passthru expression contained these errors: ERROR: File WORK.A7.DATA does not exist.... ] ] ] ] ]
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(Unknown Source)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(Unknown Source)
at com.sas.storage.iquery.BusinessQueryAdapter.init(BusinessQueryAdapter.java:178)
at com.sas.storage.iquery.BusinessQueryToTableModelAdapter.getColumnCount(BusinessQueryToTableModelAdapter.java:344)

Error occurred generating result set

java.lang.IllegalStateException: Error occurred generating result set
at com.sas.storage.iquery.BusinessQueryAdapter.init(BusinessQueryAdapter.java:201)
at com.sas.storage.iquery.BusinessQueryToTableModelAdapter.getColumnCount(BusinessQueryToTableModelAdapter.java:344)
at javax.swing.JTable.createDefaultColumnsFromModel(JTable.java:936)
at com.sas.swing.visuals.tableview.TableView.tableChanged(TableView.java:4903)
at javax.swing.JTable.setModel(JTable.java:2721)
at com.sas.apps.mapStudio.visuals.testQuery.Test.makeTableWidget(Test.java:279)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sas.apps.mapStudio.visuals.util.ProgressThread$TaskThread.run(ProgressThread.java:286)

Re: Error in Information Map Studio while testing

Cynthia_sas — Wed, 20 Jun 2007 14:33:30 GMT

Hi:
One of your problems is listed here:

2 LIBNAME DEVX ORACLE PATH=DEVX SCHEMA=DEVE ;
ERROR: ORACLE connection error: ORA-01017: invalid username/password; logon denied.
ERROR: Error in the LIBNAME statement

with the invalid username message.

However, this is really not an Enterprise Guide question and is best answered by Tech Support.

cynthia

topic Error in Information Map Studio while testing in SAS Enterprise Guide

Error in Information Map Studio while testing

Re: Error in Information Map Studio while testing