admin
Immortal
Immortal

Error creating resource type alert

When I try to create a resource type alert, I get the following
stacktrace:

22:45:13,280 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
22:45:13,280 ERROR [JDBCExceptionReporter] Batch entry 0 insert into
EAM_ALERT_DEFINITION (VERSION_COL, NAME, CTIME, MTIME, PARENT_ID,
DESCRIPTION, PRIORITY, APPDEF_ID, APPDEF_TYPE, ENABLED,
FREQUENCY_TYPE, COUNT, RANGE, WILL_RECOVER, NOTIFY_FILTERED,
CONTROL_FILTERED, ACT_ON_TRIGGER_ID, DELETED, ID) values (0,
'Platform Available', 1163918713120, 1163918713120, 0, '', 2, 10012,
1, '1', 0, 1, 0, '0', '0', '0', NULL, '0', 10061) was aborted. Call
getNextException to see the cause.
22:45:13,281 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
22:45:13,281 ERROR [JDBCExceptionReporter] ERROR: insert or update
on table "eam_alert_definition" violates foreign key constraint
"fk97540784cb32abfe"

However, executing the SQL directly works just fine. Any ideas?

Also, can we get our sequences to not increment by 10?

Charles




0 Kudos
5 Replies
admin
Immortal
Immortal

See below

Charles Lee wrote:
> When I try to create a resource type alert, I get the following
> stacktrace:
>
> 22:45:13,280 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
> 22:45:13,280 ERROR [JDBCExceptionReporter] Batch entry 0 insert into
> EAM_ALERT_DEFINITION (VERSION_COL, NAME, CTIME, MTIME, PARENT_ID,
> DESCRIPTION, PRIORITY, APPDEF_ID, APPDEF_TYPE, ENABLED,
> FREQUENCY_TYPE, COUNT, RANGE, WILL_RECOVER, NOTIFY_FILTERED,
> CONTROL_FILTERED, ACT_ON_TRIGGER_ID, DELETED, ID) values (0, 'Platform
> Available', 1163918713120, 1163918713120, 0, '', 2, 10012, 1, '1', 0,
> 1, 0, '0', '0', '0', NULL, '0', 10061) was aborted. Call
> getNextException to see the cause.
> 22:45:13,281 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
> 22:45:13,281 ERROR [JDBCExceptionReporter] ERROR: insert or update on
> table "eam_alert_definition" violates foreign key constraint
> "fk97540784cb32abfe"
I believe the stack trace is caused by an attempt to set PARENT_ID to
0. Hibernate creates a FK on parent_id now.
>
> However, executing the SQL directly works just fine. Any ideas?
>
> Also, can we get our sequences to not increment by 10?
will take care of this.
>
> Charles
>
>
>

0 Kudos
admin
Immortal
Immortal

I should point out that I had inserted a row of ID 0 manually when I
thought that this might be the case, restarted the server, and the
stacktrace that I sent was after doing all that.

Charles


On Nov 18, 2006, at 11:24 PM, Young Lee wrote:

> See below
>
> Charles Lee wrote:
>> When I try to create a resource type alert, I get the following
>> stacktrace:
>>
>> 22:45:13,280 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
>> null
>> 22:45:13,280 ERROR [JDBCExceptionReporter] Batch entry 0 insert
>> into EAM_ALERT_DEFINITION (VERSION_COL, NAME, CTIME, MTIME,
>> PARENT_ID, DESCRIPTION, PRIORITY, APPDEF_ID, APPDEF_TYPE, ENABLED,
>> FREQUENCY_TYPE, COUNT, RANGE, WILL_RECOVER, NOTIFY_FILTERED,
>> CONTROL_FILTERED, ACT_ON_TRIGGER_ID, DELETED, ID) values (0,
>> 'Platform Available', 1163918713120, 1163918713120, 0, '', 2,
>> 10012, 1, '1', 0, 1, 0, '0', '0', '0', NULL, '0', 10061) was
>> aborted. Call getNextException to see the cause.
>> 22:45:13,281 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
>> 22:45:13,281 ERROR [JDBCExceptionReporter] ERROR: insert or
>> update on table "eam_alert_definition" violates foreign key
>> constraint "fk97540784cb32abfe"
> I believe the stack trace is caused by an attempt to set PARENT_ID
> to 0. Hibernate creates a FK on parent_id now.
>>
>> However, executing the SQL directly works just fine. Any ideas?
>>
>> Also, can we get our sequences to not increment by 10?
> will take care of this.
>>
>> Charles
>>
>>
>>


0 Kudos
admin
Immortal
Immortal

Charles,

I copied the insert statement a created a xx.sql file. I get a FK
violation on parent_id.

youngl[hq] $ psql hq<xx.sql
ERROR: insert or update on table "eam_alert_definition" violates
foreign key constraint "fk97540784cb32abfe"
DETAIL: Key (parent_id)=(0) is not present in table "eam_alert_definition".

- Young

Charles Lee wrote:
> I should point out that I had inserted a row of ID 0 manually when I
> thought that this might be the case, restarted the server, and the
> stacktrace that I sent was after doing all that.
>
> Charles
>
>
> On Nov 18, 2006, at 11:24 PM, Young Lee wrote:
>
>> See below
>>
>> Charles Lee wrote:
>>> When I try to create a resource type alert, I get the following
>>> stacktrace:
>>>
>>> 22:45:13,280 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
>>> 22:45:13,280 ERROR [JDBCExceptionReporter] Batch entry 0 insert into
>>> EAM_ALERT_DEFINITION (VERSION_COL, NAME, CTIME, MTIME, PARENT_ID,
>>> DESCRIPTION, PRIORITY, APPDEF_ID, APPDEF_TYPE, ENABLED,
>>> FREQUENCY_TYPE, COUNT, RANGE, WILL_RECOVER, NOTIFY_FILTERED,
>>> CONTROL_FILTERED, ACT_ON_TRIGGER_ID, DELETED, ID) values (0,
>>> 'Platform Available', 1163918713120, 1163918713120, 0, '', 2, 10012,
>>> 1, '1', 0, 1, 0, '0', '0', '0', NULL, '0', 10061) was aborted. Call
>>> getNextException to see the cause.
>>> 22:45:13,281 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
>>> 22:45:13,281 ERROR [JDBCExceptionReporter] ERROR: insert or update
>>> on table "eam_alert_definition" violates foreign key constraint
>>> "fk97540784cb32abfe"
>> I believe the stack trace is caused by an attempt to set PARENT_ID to
>> 0. Hibernate creates a FK on parent_id now.
>>>
>>> However, executing the SQL directly works just fine. Any ideas?
>>>
>>> Also, can we get our sequences to not increment by 10?
>> will take care of this.
>>>
>>> Charles
>>>
>>>
>>>
>

0 Kudos
admin
Immortal
Immortal

Did you manually insert the row of ID 0 like I did?

Charles



On Nov 19, 2006, at 8:41 AM, Young Lee wrote:

> Charles,
>
> I copied the insert statement a created a xx.sql file. I get a FK
> violation on parent_id.
>
> youngl[hq] $ psql hq<xx.sql
> ERROR: insert or update on table "eam_alert_definition" violates
> foreign key constraint "fk97540784cb32abfe"
> DETAIL: Key (parent_id)=(0) is not present in table
> "eam_alert_definition".
>
> - Young
>
> Charles Lee wrote:
>> I should point out that I had inserted a row of ID 0 manually when
>> I thought that this might be the case, restarted the server, and
>> the stacktrace that I sent was after doing all that.
>>
>> Charles
>>
>>
>> On Nov 18, 2006, at 11:24 PM, Young Lee wrote:
>>
>>> See below
>>>
>>> Charles Lee wrote:
>>>> When I try to create a resource type alert, I get the following
>>>> stacktrace:
>>>>
>>>> 22:45:13,280 WARN [JDBCExceptionReporter] SQL Error: 0,
>>>> SQLState: null
>>>> 22:45:13,280 ERROR [JDBCExceptionReporter] Batch entry 0 insert
>>>> into EAM_ALERT_DEFINITION (VERSION_COL, NAME, CTIME, MTIME,
>>>> PARENT_ID, DESCRIPTION, PRIORITY, APPDEF_ID, APPDEF_TYPE,
>>>> ENABLED, FREQUENCY_TYPE, COUNT, RANGE, WILL_RECOVER,
>>>> NOTIFY_FILTERED, CONTROL_FILTERED, ACT_ON_TRIGGER_ID, DELETED,
>>>> ID) values (0, 'Platform Available', 1163918713120,
>>>> 1163918713120, 0, '', 2, 10012, 1, '1', 0, 1, 0, '0', '0', '0',
>>>> NULL, '0', 10061) was aborted. Call getNextException to see the
>>>> cause.
>>>> 22:45:13,281 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
>>>> 22:45:13,281 ERROR [JDBCExceptionReporter] ERROR: insert or
>>>> update on table "eam_alert_definition" violates foreign key
>>>> constraint "fk97540784cb32abfe"
>>> I believe the stack trace is caused by an attempt to set
>>> PARENT_ID to 0. Hibernate creates a FK on parent_id now.
>>>>
>>>> However, executing the SQL directly works just fine. Any ideas?
>>>>
>>>> Also, can we get our sequences to not increment by 10?
>>> will take care of this.
>>>>
>>>> Charles
>>>>
>>>>
>>>>
>>


0 Kudos
admin
Immortal
Immortal

Ah. I inserted the row into a different tablespace :-). I will
update dbsetup to add a row for ID 0.

Charles



On Nov 19, 2006, at 11:11 AM, Charles Lee wrote:

> Did you manually insert the row of ID 0 like I did?
>
> Charles
>
>
>
> On Nov 19, 2006, at 8:41 AM, Young Lee wrote:
>
>> Charles,
>>
>> I copied the insert statement a created a xx.sql file. I get a FK
>> violation on parent_id.
>>
>> youngl[hq] $ psql hq<xx.sql
>> ERROR: insert or update on table "eam_alert_definition" violates
>> foreign key constraint "fk97540784cb32abfe"
>> DETAIL: Key (parent_id)=(0) is not present in table
>> "eam_alert_definition".
>>
>> - Young
>>
>> Charles Lee wrote:
>>> I should point out that I had inserted a row of ID 0 manually
>>> when I thought that this might be the case, restarted the server,
>>> and the stacktrace that I sent was after doing all that.
>>>
>>> Charles
>>>
>>>
>>> On Nov 18, 2006, at 11:24 PM, Young Lee wrote:
>>>
>>>> See below
>>>>
>>>> Charles Lee wrote:
>>>>> When I try to create a resource type alert, I get the following
>>>>> stacktrace:
>>>>>
>>>>> 22:45:13,280 WARN [JDBCExceptionReporter] SQL Error: 0,
>>>>> SQLState: null
>>>>> 22:45:13,280 ERROR [JDBCExceptionReporter] Batch entry 0 insert
>>>>> into EAM_ALERT_DEFINITION (VERSION_COL, NAME, CTIME, MTIME,
>>>>> PARENT_ID, DESCRIPTION, PRIORITY, APPDEF_ID, APPDEF_TYPE,
>>>>> ENABLED, FREQUENCY_TYPE, COUNT, RANGE, WILL_RECOVER,
>>>>> NOTIFY_FILTERED, CONTROL_FILTERED, ACT_ON_TRIGGER_ID, DELETED,
>>>>> ID) values (0, 'Platform Available', 1163918713120,
>>>>> 1163918713120, 0, '', 2, 10012, 1, '1', 0, 1, 0, '0', '0', '0',
>>>>> NULL, '0', 10061) was aborted. Call getNextException to see
>>>>> the cause.
>>>>> 22:45:13,281 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
>>>>> 22:45:13,281 ERROR [JDBCExceptionReporter] ERROR: insert or
>>>>> update on table "eam_alert_definition" violates foreign key
>>>>> constraint "fk97540784cb32abfe"
>>>> I believe the stack trace is caused by an attempt to set
>>>> PARENT_ID to 0. Hibernate creates a FK on parent_id now.
>>>>>
>>>>> However, executing the SQL directly works just fine. Any ideas?
>>>>>
>>>>> Also, can we get our sequences to not increment by 10?
>>>> will take care of this.
>>>>>
>>>>> Charles
>>>>>
>>>>>
>>>>>
>>>
>


0 Kudos