Gah!

[dcseain]

IF the bloody page ever comes up, i can unlock the record and go home, seeing as even once i get the data i need, i can't fix it because the DB table still has not reappeared. If i can't change the P to a U in the missing table, it'l all for nought. Sigh. I will get to go home soonish. I hope.

Comments

[nosebeepbear.livejournal.com]

Argh. I hate it when databases fight back. Hope it's resolved soon.

[dcseain.livejournal.com]

It's back today, but nothing seems to be transmitting from the DB to the front end system. Sigh. I'll need to ping the DB guy if nothing transmits in the next 2 hrs.

[ksatyr.livejournal.com]

Sounds like a missing option in a constraint. Databases do BDSM badly, I've found. I had a similar problem with a table that needs to allow a column to have "DGRAM" as well as "TCPIP", "DIALUP" and "RS232."

Fixed it with a "constraint CKC_COMM_CHANNEL_DEF_CTN check (COMM_TYPE_NAME in ('RS232','DIALUP','TCPIP','DGRAM')),"

[dcseain.livejournal.com]

Mullineaxd, the DB guy, was playing with it and made it disappear. I agree that it was likely a constraint issue. Happily, the table be back today, so all's well.

[dcseain.livejournal.com]

Sigh. It's back up, but nothing seems to be transmitting from the backend DB to the frontend system. I bet he broke table joins. Sigh.

[(Anonymous)]

Or possibly - after deleting the table and re-creating it, he didn't "grant all to public" so only the db admin account can access the table.

Is this Oracle, Sybase or something else entirely?

[ksatyr.livejournal.com]

Hmm, that anonymous post was from me.

[dcseain.livejournal.com]

I figured. I can see the table, both through TOAD and through SQL*PLus. I've updated the table in question. It's just not transmitting after commit to the frontend. It's Oracle 9i.

[ksatyr.livejournal.com]

All I can suggest is to issue from SQL*Plus (the most annoying tool I've ever come across, by the way) the following two lines:

grant all on TABLENAME to public;

and then

create public synonym TABLENAME for username.COMM_CHANNEL_DEF;

Where username is whatever user the front end logs to the database as.