Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
How to access the table which is not created from database configuration application by using custom cron
July 7, 2016
11:22 am
Avatar
Sudhindra Shivanagere
Member
Members
Forum Posts: 13
Member Since:
September 22, 2014
sp_UserOfflineSmall Offline

Hi All,

I am trying to access a TABLE T1 in database TEST schema but my cronjob will run in MAXIMO schema.
So i am getting the below error.

e1-psdi.util.MXUnknownObjectException: BMXAA4216E – Unknown Object has been encountered. Gather the
logs from the <HOME> directory and determine the cause and source of the error.

Reason for the Error is:
There is no Table T1 config details are present in OBJECT CONFIG and Attribute config maximo default tables in MAXIMO schema.
The table T1 is created from backend (using sql create script) in the TEST schema so how access the table T1 in TEST schema from cron.

Below is the custom code which i have written to access T1 in Test schema (Provided all the grants like delete, select etc and synonyms)
but its not working as excepted.

MboSetRemote Testset_T1= mxserver.getMboSet(“T1”, userInfo);
Testset_T1.setWhere(“Location=’BANGALORE'”);

Could you please let me know how to access the table which is not present in the database configuration.
Need to access the table which is created from sql script instead of database configuration application.

Thanks in advance.

Thanks,
Sudhindra

July 26, 2016
1:02 pm
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

cgregory: 45

Maximofresher: 45

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 14366

Moderators: 0

Admins: 4

Forum Stats:

Groups: 1

Forums: 8

Topics: 1580

Posts: 4295

Newest Members:

Megan Morgan, Devendra Verma, stephen stephens, maxexpertise Hilal, Jeroen van Proosdij, Neeraja N

Administrators: Chon: 1118, kristensibilia: 0, Joe Grassia: 0, bpaik: 0