IPCC Database Insert

Unanswered Question
Jan 10th, 2010

Hello everyone,

I have an environment of two servers: CCM 4.X and IPCC 4.0.5

I wish to insert a few records into its SQL DB (in the cdr_records table), these records represents a period where the IPCC server was down.

Although I can insert these records into the DB with no problems.

I want to understand how the IPCC inserts into its DB. I think it would one of either way:

A- It simply looks for the index of last record in the table (i.e. N) then increments and adds to the table at row  (N+1)

B- It has its internal index and simply increments on that.

If it's case B, I'm afraid that it would overwrite other data of other periods.

Really appreciate the response.



I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Tanner Ezell Mon, 01/11/2010 - 15:32

The answer is B, it must be keeping it's own internal index. If you manually insert into the table, it requires you specify the SessionID. This would not happen if the column was set to auto increment.

Nathan Luk Mon, 01/11/2010 - 16:56

What I've done before which seems to have worked ok is just used a negative value for sessionid (since the generated sessionid's are always positive and the column datatype accepts negatives this seems to work ok without having values get overwritten).




This Discussion