I've attached a spreadsheet where I've altered the names/pintokens, etc. It clearly show the user with the missing storage id, but as I look at a working system, I see some users with a missing storage ID without the problem of adding or modifying users. So I am not confident that this is nothing more than a dead end.
Since the errors are LUCENE, and related to tapestry, it makes more sense to me this is a tapestry/java error. No users were manually created. When the system was first built, the initial users were imported via csv, and it threw no errors and the job was successful, the errors starting occurring 2-3 days after the system was built. The errors point to data being out of order, I know, but I did not make any changes to the data manually. 1. Build system from ISO. 2. Import users 3. Configure gateways, other parameters 4. Import certificate for google. 5. upload certificate for system. 6. days later import google addresses (large number) and sipxconfig becomes unresponsive, restart configserver 7. Added user, could not assign alias afterwards. 8. Cannot add or modify ANY users, system useable but unmanageable anymore. If I do a drop database and restore from backup, I don't have much hope my issue will be resolved if the issue is with the DB (i.e., I would be importing the same error that caused this to begin with). I'd like to understand what caused this, because the way I built it was very "normal". The export was from a 4.0.4 system, on a new domain, so the pintokens and such were cleared from the csv file (as well as the superadmin account), before importing. It was just a successful users import, the job status showed no issues whatsoever. I don't think it's an index problem. I've run a manual reindex of all the tables, nothing has changed. Is there anywhere I can look closer to find out what is the matter or how to fix it? On Tue, May 11, 2010 at 5:32 AM, Tony Graziano <[email protected] > wrote: > no. > > Once the import failed I did look at the postgres table (view). Saw the > last user entered, which I was not able to configure an alias for, does not > have a "value_storage_id" set. > > I suspect this is an issue because the "order" is being affected when the > row is trying to be written or altered. > > If so, how do I fix it? > > > On Tue, May 11, 2010 at 5:01 AM, George Niculae < > [email protected]> wrote: > >> >> --- On Tue, 5/11/10, Tony Graziano <[email protected]> wrote: >> >> >To confirm this, I get a "docs out of order" message trying to import 1 >> >user. >> > >> >The import fails with: >> >docs out of order (-2 < 0 ) >> >> Just wondering if you manually inserted users in db (or any other way but >> not via sipxconfig) >> >> George >> >> >> >> >> > > > -- > ====================== > Tony Graziano, Manager > Telephone: 434.984.8430 > sip: [email protected] > Fax: 434.984.8431 > > Email: [email protected] > > LAN/Telephony/Security and Control Systems Helpdesk: > Telephone: 434.984.8426 > sip: [email protected] > Fax: 434.984.8427 > > Helpdesk Contract Customers: > http://www.myitdepartment.net/gethelp/ > > Why do mathematicians always confuse Halloween and Christmas? > Because 31 Oct = 25 Dec. > > -- ====================== Tony Graziano, Manager Telephone: 434.984.8430 sip: [email protected] Fax: 434.984.8431 Email: [email protected] LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: [email protected] Fax: 434.984.8427 Helpdesk Contract Customers: http://www.myitdepartment.net/gethelp/ Why do mathematicians always confuse Halloween and Christmas? Because 31 Oct = 25 Dec.
sample-db-missing-storage_id.xls
Description: MS-Excel spreadsheet
_______________________________________________ sipx-dev mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-dev Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-dev sipXecs IP PBX -- http://www.sipfoundry.org/
