Home > Cannot Complete > Cannot Complete Your Request Because The Database Is Being Referenced

Cannot Complete Your Request Because The Database Is Being Referenced

If this error happens frequently, instruct spreadsheet users to clear the “Update Mode” option. If this error happens frequently, ensure that users are not starting complex calculations and logging off Essbase before the calculation is completed. All Rights Reserved Privacy & Terms current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Link to image tutorial Tutorial: http://www.imageno.com/wz6gv1wuqajrpic.html (sorry, I don't have enough reputation to upload images here :P) share|improve this answer answered Aug 30 at 14:32 Marco 11 add a comment| up have a peek at these guys

If you are using ESSCMD, you may need to add sleep commands to Ensure that the archive process is completed before the next process begins. 1014026Requested lock is currently held by I used it for altering PK, but idea the same. If this error happens frequently, ensure that users are not starting complex calculations and logging off Essbase before the calculation is completed. This is why DELETE works and TRUNCATE TABLE doesn't: because the database is able to make sure that it isn't being referenced by another record. http://hyperionplanningandmore.blogspot.com/2013/05/unlocking-applications.html

E.g. Since I have Storefront installed on each ddc, I enabled 443 on load balanced hostname only and use http otherwise to reference the ddc servers (such as sta settings and delivery We have a HAL process which updates dimensions and performs data load every night.

Since I have Storefront installed on each ddc, I enabled 443 on load balanced hostname only and use http otherwise to reference the ddc servers (such as sta settings and delivery Truncating Process Specific Tables...' -- TRUNCATE TABLE IF IT ALREADY EXISTS TRUNCATE TABLE [Internal_FK_Definition_Storage] END ELSE PRINT '1. You must be logged in to score posts.Respond to this messageAuthorReplyessbase.ru81.89.71.154restore essbase backupNo score for this postFebruary 20 2009,1:20 AM can u export DB to text and recreate database ? You must be logged in to score posts.Respond to this messageZaky203.190.180.49Re: Planning Refresh not workingNo score for this postFebruary 24 2009,9:30 PMLast Resort, restart the sql server and planning server?

Essbase will keep trying until it reaches the specified wait time.Essbase could not lock an object. This process had failed 3 days ago due to a power outage but we were able to get the process working again after the incident. Calling the DB creation script from within integration tests is ... Abdul Muqeet - Oracle Hyperion Blog Sunday, August 12, 2012 Unable to Refresh Database or Security in Hyperion Planning Desktop Unable to Refresh Database or Security in Hyperion Planning Desktop Applies

By using our services, you agree to our use of cookies.Learn moreGot itMy AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsBooksbooks.google.comhttps://books.google.com/books/about/Yazoo_Basin_Abiaca_Creek_Watershed_Demon.html?id=9DI0AQAAMAAJ&utm_source=gb-gplus-shareYazoo Basin, Abiaca Creek Watershed Demonstration Erosion Control ProjectMy libraryHelpAdvanced Book SearchDownload PDFeBook If this error is happening because spreadsheet users are locking objects, increase the values for LOCKTIMEOUT. See stackoverflow.com/questions/3843806/… –Lynn Crumbling Jul 17 '12 at 18:59 3 doesn't work if you have a FK constraint –WeDoTDD.com Nov 28 '12 at 6:11 1 even with 2012 this I'd like to do it in the Setup method of integration tests.

http://support.citrix.com/article/CTX133904 Thanks, romatlo Attached Thumbnails 1316-345793-1787624 Back to top Oneil Matlock Members #2 Oneil Matlock 240 posts Posted 11 December 2013 - 04:33 PM I believe this is resolved http://discussions.citrix.com/topic/345793-cannot-complete-your-request/ Typically my process for this is: Drop the constraints Trunc the table Recreate the constraints. (All in a transaction, of course.) Of course, this only applies if the child has already You must be logged in to score posts.Respond to this messagea.hyperion146.131.120.2Restart did not work..... Oracle support has been trying to drop the ball by getting into too much detail about the specific versions of server, backends and other supporting software rather than looking into the

You must be logged in to score posts.Respond to this messagezaky203.190.180.49Re: Planning Refresh not workingNo score for this postFebruary 24 2009,1:35 AMHi, You might want to look at your hyperion folder. More about the author You must be logged in to score posts.Respond to this messagea.hyperion146.131.120.2Had ghost HAL but not the culpritNo score for this postFebruary 24 2009,10:13 AMYou are right about ghost HAL process and i've made a script that drop all constrainsts and then recreate then. Check the physical memory on the server computer.

Hot Network Questions How to convert numbers to currency values? so, @M07, please don't say a "delete from approach is cleaner", because that's just not remotely accurate. –ctb Mar 16 at 20:07 After deleting large data, user have to Any pointers would help! check my blog You must be logged in to score posts.Respond to this messagea.hyperion99.229.91.101There are no locks on DB or Essbase objectsNo score for this postFebruary 20 2009,12:03 PMI have already checked for locks

Word for "using technology inappropriately"? Creating Process Specific Tables...' -- CREATE STORAGE TABLE IF IT DOES NOT EXISTS CREATE TABLE [Internal_FK_Definition_Storage] ( ID int not null identity(1,1) primary key, FK_Name varchar(250) not null, FK_CreationStatement varchar(max) not See if another user has locked the file (see Unlocking Objects).

not the first solution I'll go to. –ripper234 May 6 '10 at 6:39 add a comment| up vote 4 down vote You cannot truncate a table if you don't drop the

Not the answer you're looking for? When the archival process finishes, issue the ENDARCHIVE command. 1014040Failed to get the current thread's handle. operation abortedContact Oracle Support. 1014042Failed to get the current thread's high priority. I am using two delivery controllers, two storefront servers, and separate SQL 2012 database.

Saving the Diagram brought up a Save dialog box, than a "Changes were made in the database while you where working" dialog box, clicking Yes restored the Key, restoring it from Contact Oracle Support. Maybe it does for newer versions? –Coops Aug 2 '13 at 12:51 This worked for me in Windows Azure MS SQL, so maybe... –Serj Sagan Aug 3 '13 at news Please re-enable javascript to access full functionality.

One more thing.. If ESSBASEPATH/bin/essbase.cfg does not exist on the server computer, create one using a text editor. Take the backup of the table HSP_LOCK before deleting the line in the table.Delete the row in HSP_LOCK. 2. So I tried the following steps in this order: 1) Close HAL 2) Stopped EB services 3) Access Planning server and run the unlockapp.exe app for all of your Planning applications

a. 1. Restart Hyperion Services. Delete the row in HSP_LOCK table. You must be logged in to score posts.Respond to this messageAnonymous146.131.120.2Re: Planning Refresh not workingNo score for this postFebruary 24 2009,10:16 AMZaky, I checked the app and database folders for any

The server will show you the name of the restriction and the table, and deleting that table you can delete what you need. In a Windows environment, 64 MB is the suggested minimum for one database. Dropping Foreign Keys...' -- DROP FOREING KEYS SET @i = 1 WHILE (@i <= (SELECT MAX(ID) FROM [Internal_FK_Definition_Storage])) BEGIN SET @ConstraintName = (SELECT FK_Name FROM [Internal_FK_Definition_Storage] WHERE ID = @i) SET Corps of EngineersPublished1993Original fromNorthwestern UniversityDigitizedJul 26, 2012  Export CitationBiBTeXEndNoteRefManAbout Google Books - Privacy Policy - TermsofService - Blog - Information for Publishers - Report an issue - Help - Sitemap - GoogleHome

The question is for MSSQL. –Michael May 23 '14 at 13:25 1 This is MySQL code - not relevant. –jbright Apr 27 at 14:45 add a comment| up vote 0 How can I avoid being chastised for a project I inherited which was already buggy, but I was told to add features instead of fixing it? Is it unethical to poorly translate an exam from Dutch to English and then present it to the English speaking students? operation abortedContact Oracle Support. 1014035Failed to allocate lock manager waiter node.

Backing up Foreign Key Definitions...' -- Fetch and persist FKs WHILE (@i <= (SELECT MAX(ID) FROM #FKs)) BEGIN SET @ConstraintName = (SELECT ConstraintName FROM #FKs WHERE ID = @i) SET @TableName You must be logged in to score posts.Respond to this messagea.hyperion99.229.91.101Check all tables and locks on databases in SQL tooNo score for this postFebruary 20 2009,3:22 PMJC, That is exactly what In the ESSBASEPATH/bin/essbase.cfg file on the server computer, add or increase the value for LOCKTIMEOUT. In a Windows environment, 64 MB is the suggested minimum for one database.

In a UNIX environment, 128 MB is the suggested minimum for one database. If this error is happening because spreadsheet users are locking objects, increase the values for LOCKTIMEOUT. What did John Templeton mean when he said that the four most dangerous words in investing are: ‘this time it’s different'? Symptoms Unable to refresh the database or security filters in planning.