Cognos Error Number 45
Contents |
ini file could not be found Technote (troubleshooting) Problem(Abstract) Query Server Error Error number -45: DMS-E-YV_SGINOTSUPP, The database type 'attach database' associated with the database cognos impromptu error name '?' is not supported DMS-E-DBDLL_NOTFOUND, the dynamic link library "unknown check cognos error traceback ini file" could not be found in the search path. when attempting to run an Impromptu report against an cognos error qe-def-0260 Oracle 8.x database natively on Win95, Win98, WinNT, Win2000 platforms. Resolving the problem 1. In the Cogdmor.ini file, under the [DLL Names] section, ensure that the entries looks similar to cognos error 'sqlopenresult' status='-28' the following. Do a search on your machine for OR*.dll, if OR805.DLL is found in your search then ensure there is an entry like that marked * below. Similarly, if OR815.DLL is found in your search then there should be an entry like that marked *** below. [DLL Names] ; ; Uncomment the following entries to ensure that a specific version is
Cognos Error Dpr-err-2101
used. ; ;Default Win32=OR71-Win32 ;Default Win16=OR72 OR815-Win32=ORACLIENT8.DLL,8.1 <-- *** OR805-Win32=ORA805.DLL,7.1 <-- * OR804-Win32=ORA804.DLL,7.1 OR803-Win32=ORA803.DLL,7.1 OR73-Win32=ORA73.DLL,7.3 OR72-Win32=ORA72.DLL,7.2 OR71-Win32=ORANT71.DLL,7.1 OR805=ORA805.DLL,8.0 OR804=ORA804.DLL,8.0 OR803=ORA803.DLL,8.0 OR73=ORA73WIN.DLL,7.3 OR72=ORA72WIN.DLL,7.2 OR71=ORA71WIN.DLL,7.1 OR70=ORA7WIN.DLL,7.0 OR60=ORA7WIN.DLL,6.0 2. Check the path. In Command Prompt, type PATH. Ensure that there is an entry that points to the Oracle entry bin directory. For example: x:\ORANT\bin. 3. If the path has been manually edited, check that the path does not have any entries with spaces in it. If it does, remove the spaces and use 8.3 path naming conventions. 4. Use Oracle client utlity - SQL PLUS x.x - to test that you can connect to the database before re-running your report in Impromptu. Cross reference information Segment Product Component Platform Version Edition Business Analytics Cognos Planning Contributor Historical Number 108621 Document information More support for: Cognos Series 7 Impromptu Software version: Impromptu 5.0, Impromptu 6.0, Impromptu 7.1, Planning - Contributor 7.3 Operating system(s): Platform Independent, Windows Reference #: 1336994 Modified date: 2014-09-12 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
with restrictions (on forms) try to load data (e.g. via
Cognos Error Dpr-err-2082
an import spec), especially after upgrade Technote (troubleshooting) Problem(Abstract) Restricted users cognos error log (those with a security group on their forms) try to import data (with an import specification). cognos error 1053 These users receive an error message. Typically this worked before a recent upgrade (of Controller). Symptom Error code 45 - the account is locked for update. http://www-01.ibm.com/support/docview.wss?uid=swg21336994 Cause Change in functionality in Controller (from version 10.1.2163 onwards). More Details: There has been a deliberate change in the security for 'import data' and 'export from excel' (fExpVal). Specifically, the user must have 'write' access (not just read access) to the accounts they are importing to. Environment This behaviour is often http://www.ibm.com/support/docview.wss?uid=swg21663234 seen after customers upgrade from an earlier version (10.1.2159 or older) to a later version (10.1.2163 or later) of Controller Resolving the problem Fix: There are several methods to fix the problem: 1. Remove the relevant 'form security group' from the 'bad' users 2. Import the values using an administrative (unrestricted) user account (e.g. ADM) 3. Modify the security permissions (on the form) for the accounts that are to be imported, so that the users have write access to them TIP: It may also be necessary to use submissions (so that some data can be locked once loaded). Related information 1692442 - Excel link spreadsheet values are zero (0) af Document information More support for: Cognos Controller Controller Software version: 10.1.1 Operating system(s): Windows Reference #: 1663234 Modified date: 2014-12-10 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts http://www.tek-tips.com/viewthread.cfm?qid=443939 Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best http://www.cognoise.com/index.php?topic=15328.0 Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To cognos error Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Cognos solutions Forum at Tek-Tips HomeForumsProject and Data ManagementData Management Programming ToolsCognos solutions Forum Impromptu Query Server Error thread401-443939 Forum Search FAQs Links MVPs Impromptu Query Server Error Impromptu Query Server Error po944he (TechnicalUser) (OP) 9 Jan 03 cognos error number 10:40 I am converting a user from a win98 desktop to a win2K laptop the Costpoint and Sql-Talk run fine but Impromptu gives me an error when I try to open something from the network, it otherwise runs fine.Error number -45:DMS-E-YV-SGINOTSUPP,The database type 'attach database'associated with the database name '?' is not supported.DMS-E-DBLL_NOTFOUND, The dynamic link library'
and session length News: Stay connected throught Twitter - Avnet Services, Twitter - Avnet Academy, LinkedIn, Facebook, Google+ and YouTube.Check out the latest IBM Cognos tips and tricks in the BSP Chronicles. Join our Mailing List. Home Help Search Calendar Login Register COGNOiSe.com - The IBM Cognos Community » Legacy Business Intelligence » COGNOS Impromptu » Impromptu 7.3 is compatible with Windows 7 ? « previous next » Print Pages: [1] Author Topic: Impromptu 7.3 is compatible with Windows 7 ? (Read 14235 times) MaryPoppins Associate Join Date: Nov 2010 Posts: 4 Forum Citizenship: +0/-0 Impromptu 7.3 is compatible with Windows 7 ? « on: 29 Jun 2011 06:18:56 am » I have done a lot of searching on this topic and am coming up cold. Can anyone tell me if Impromptu v7.3 is compatible with Windows 7?and if you know where to find this information on the IBM site? because I have to prove to my clientThank you for any help Logged MFGF Never knowingly correct Super Moderator Statesman Join Date: Jul 2005 Posts: 8,895 Forum Citizenship: +537/-7 Cognos Software Muppet Re: Impromptu 7.3 is compatible with Windows 7 ? « Reply #1 on: 29 Jun 2011 06:38:59 am » Hi,I think the answer is almost certainly no. The IBM Support Site shows that 7.3 is now out of support altogether:https://www-304.ibm.com/support/docview.wss?uid=swg27014713#icThe oldest supported version is 7.4 before any of the maintenance releases. A quick look at the Supported Environments page for it shows Windows 7 is not a valid platform.https://www-304.ibm.com/support/docview.wss?rs=3635&uid=swg27014098I'd take it as pretty much read that 7.3 will not work on Windows 7 too.Regards,MF. Logged Meep! davidf2011 Associate Join Date: Aug 2011 Posts: 2 Forum Citizenship: +0/-0 Re: Impromptu 7.3 is compatible with Windows 7 ? « Reply #2 on: 31 Aug 2011 04:24:20 am » I have installed impromptu 7.3 on windows 7 64bit, it works fine. the installer needs to have compatibility settings set to xp to actually install though.hope this helps Logged davidf2011 Associate Join Date: Aug 2011 Posts: 2 Forum Citizenship: +0/-0 Re: Impromptu 7.3 is compatible with Windows 7 ? « Reply #3 on: 04 Jan 2012 10:55:55 am » it also needs a slight modification of the installation director