Find Answers

Filter Search Results
All Products:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML Problems after deploy of new tables - lastids and other issues
Problems after deploy of new tables - lastids and other issues
CMS-XML Users are required to provide their current password when they attempt to change their password or e-mail address in their user profile.
To change this default behavior: 1. Allocate a new TS_ID for the new Setting record to be added by updating the TS_ LASTIDS table. UPDATE TS_LASTIDS SET TS_LASTID = TS_LASTID + 1 WHERE TS_TABLEID = 56;
CMS-XML Changing Default Size of Data ScriptPage Writes to Shell::PostData using SBM ModScript
TS_DATATYPE = 1 TS_LONGVALUE = the desired limit for POST data (in bytes) Increment the last ID for the TS_SYSTEMSETTINGS row in the TS_ LASTIDS table by 1.
CMS-XML SBM Application Engine Consumes Large Amounts of Memory When Running Listing Reports
If you detect a spike in memory usage by Application Engine, perform the following steps: 1. Allocate a new TS_ID for the new setting record by updating the TS_ LASTIDS table. UPDATE TS_LASTIDS SET TS_LASTID = TS_LASTID + 1 WHERE TS_TABLEID = 56;
CMS-XML Double byte characters corrupted when imported to MS Project from SBM
Korean KS_C_5601-1987 2. TS_SYSTEMSETTINGS table, set "Pre-Unicode Charset' value to correct character set, for example, GB2312. If there is no such entry in the TS_SYSTEMSETTINGS table, add this entry and set value to correct character set, also you need to modify TS_ LASTIDS table to reflect the changed lastID number for TS_SYSTEMSETTINGS table as well.
CMS-XML Email Submit and Notelogger doesn't work in SBM 11 if you start with a brand new database ( Not sample db )
To workaround run the following sql queries against the Application Engine database. Update TS_ LASTIDS set TS_ LASTID =2 where TS_TABLEID = 230 Insert TS_MAILSUBMITREGISTRY values (1, null, 0);
CMS-XML Smart Search indexing does not complete for certain tables.
INFO 09-01-2014 09:35:16 [IndexerProcess] -- Start index creation for table USR_TEST(1000) DEBUG 09-01-2014 09:35:16 [IndexerServiceImpl] -- GetNextItems tableId: 1000 lastId : 0 returned 16 Items in 13 millis. INFO 09-01-2014 09:35:16 [IndexerProcess] -- Indexer process 80 finished(time: 0 secs)
CMS-XML Disabling Preference Warning in Application Administrator When New Users Are Added to Groups - Warning: - Group preferences are not automatically apply
To disable this warning: 1. Allocate a new TS_ID for the new Setting record by updating the TS_ LASTIDS table. UPDATE TS_LASTIDS SET TS_LASTID = TS_LASTID + 1 WHERE TS_TABLEID = 182;
CMS-XML SBM 11.3 upgrade fails with ORA-04080 error
drop trigger TRG_CP_TO_REL_CHANGEACTIONS drop trigger TRG_CP_TO_REL_ADMINCHANGES drop procedure PRC_UPDATE_ LASTID
CMS-XML An exception occurred while attempting to calculate the next ID number to be used for the "table" - error: Unable to get next id for tableid ... Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim
When attempting to calculate " lastid " values for AE tables, the SQL used could sometimes cause deadlocks and slowing down of the AE interface. Upgrading to 10.1.5 clears up the issue by modifying the queries used when updating tables.
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs