cancel
Showing results for 
Search instead for 
Did you mean: 

Agentry - getUserName.sql Issue

Former Member
0 Kudos

I'm getting the following error with my Agentry application:

2014/08/21 11:07:12.048:      + Query=BackEnd SqlBE.ini [Misc] getUserName=getUserName.sql
2014/08/21 11:07:12.048:        *** Cannot load file getUserName.sql (file not found)
2014/08/21 11:07:12.048:        : 3 lines, 0 non-printing characters, 106 total characters

3: SA_DBMS_API_Error, vendor says:

>ERROR  900:42000 [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

The getUserName.sql file is definitely there in the sql folder.  Here are the contents of my SqlBE.ini file:

; The [Misc] section queries are required

[Misc]

backEndTimeAndDate=backEndTimeAndDate.sql

getUserName=getUserName.sql

; Queries may be added to the following sections:

; Queries to run when the server connects to the database

[DbConnect]

; Queries to run before the server disconnects from the database

[DbDisconnect]

; Queries to run on each DB connection when that connection is created

[DbConnectionInit]

; Queries to run when a user attempts to log into the server

[ValidateUser]

q1=validateUser.sql

; Queries to run when a user attempts to re-log into the server

[RevalidateUser]

q1=revalidateUser.sql

; Queries to run when a previous user attempts to log into the server

[ValidatePreviousUser]

q1=validateUser.sql

; Queries to run when a user logs in

[LoggedIn]

; Queries to run when a user logs out

[LoggedOut]

; Queries to read in information for <<user.info.XXX>> (run after [LoggedIn])

[UserInfo]

; Queries to read Globals, Localization, and Enables for everyone

[ApplicationGlobals]

; Queries to read Globals, Localization, and Enables for a user

[UserGlobals]

; Queries to run when a user login fails (i.e. [ValidateUser] returns VALID=false or VALID=DB and the database does not validate)

[LoginFailed]

; Queries to run when a user login returns blocked (i.e. [ValidateUser] returns USER_BLOCKED=true or VALID=BLOCKED)

[LoginBlocked]

; Queries to run when a user changes a password

[ChangePassword]

; Queries to run when a change password attempt fails (i.e. [ChangePassword] returns SUCCESS=false)

[ChangePasswordFailed]

; Queries to run when a user is added to the push list

[EnablePush]

; Queries to run when a user is removed from the push list

[DisablePush]

; Queries to run to determine a SQL Backend's Time Zone

[TimeZone]

Any ideas how to fix this?

Tags edited by: Michael Appleby

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

In the Management Cockpit, look for the "SpicDoc" settings, set it to the following:

facePath=sql\custom;sql

Former Member
0 Kudos

I should have specified that I am using SMP 3.0 SP03.  Where would I find the SpicDoc settings?

Former Member
0 Kudos

Nevermind...I found it under the App Specific Settings tab in the application.

Answers (0)