Product:

Cognos Controller 10.3 (CONTRL_version=CCR-AW64-ML-RTM-10.3.0.169-0)

Microsoft Windows 2008 R2 Server

Oracle 12c database (version  Release 12.1.0.2.0) 64 bit

Symptom:

When connect to an Oracle Controller database you get an error during the upgrade steps inside Cognos Controller Configuration program.

Error message in DBCONV:

Running DB Step: 950

Running script batch: script/ora_950.batch

Running script: script/ora/ora_update_xmenu.sql

Running DB Step: 951

Running DB Step: 952

Running script batch: ora_952.batch

Running script: script/ora_xrclayout_add_column.sql

** ERROR: java.sql.SQLSyntaxErrorException: ORA-00904: “DBMS_LOB”.”SUBSTR”: ogiltig identifierare

ORA-06512: vid rad 12

The SQL command that give the error are:

DECLARE

sSql VARCHAR2(4000);

BEGIN

IF NOT UFNC_OBJECT_EXISTS(‘SELECT 1 FROM user_tab_COLUMNS WHERE table_name = ”XRCLAYOUT” AND column_name = ”EXCELFILEFORMAT”’) THEN

sSql := ‘ALTER TABLE XRCLAYOUT ADD EXCELFILEFORMAT number DEFAULT (0) NOT NULL’;

EXECUTE IMMEDIATE (sSql);

sSql := ‘UPDATE XRCLAYOUT SET EXCELFILEFORMAT = 56’;

EXECUTE IMMEDIATE (sSql);

sSql := ‘UPDATE XRCLAYOUT SET EXCELFILEFORMAT = 51 WHERE UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(layout, 2,1)) = ”PK”’;

EXECUTE IMMEDIATE (sSql);

END IF;

END;

Possible Solution:

There can be a setting on the Oracle database that does not allow that many connections. Please check and increase.

Please note: If you get a error during upgrade of a cognos controller database – then the database will be corrupt, because some upgrade steps will be missing. You must restore the original database and run the upgrade steps again from the beginning to ensure the database is fully functional.

It can be that you have the wrong ojdbc7.jar file in the controller folder.

Copy the correct ODBC file from the Oracle client installation on the server

Can be this folder:

C:\orarun\ora12102\Client\jdbc\lib\ojdbc6.jar

To the folders of the Cognos controller installation

that normally is these folders;

C:\Program Files\ibm\cognos\ccr_64

C:\Program Files\ibm\cognos\ccr_64\server\integration

C:\Program Files\ibm\cognos\ccr_64\server\FAP\lib

C:\Program Files\ibm\cognos\ccr_64\webapps\p2pd\WEB-INF\lib

Close the Controller Configuration and start it again so it can pick up the new driver jar file you have paste into the controller ccr_64 folder.

You can also be needing to run the DBCONV.EXE program as standalone from Cognos Controller Configuration.

Go to folder /ccr_64/ and start DBCONV.EXE

Click on the button with dots to select the correct UDL file.

Then click on Connection Button.

Now you can click on Upgrade button, and it should work better.

There can also be other cause of this issue – ensure the host name in cognos controller configuration only use the servername and not .domain.com – the new code does not accept period in server name for the data source.

 

More Information:

Cognos Controller use different connection methods to connect to ORACLE databases, like this:

ODBC = Controller Consolidation part

OLEDB = Controller Applications part

JDBC = used by DBCONV and java parts, also used by Cognos BI CQM reports

OCI  = used by Cognos BI DQM reports (not found on Cognos Controller server)

Product:
Cognos Controller 10.1 FAP
Microsoft Windows 2008 R2
Oracle Database

Error message:
** ERROR: java.sql.SQLException: IO Error: Invalid connection string format, a valid format is: “host:port:sid”

Problem:
When you setup the Cognos Controller FAP database, you need to populate it with tables by using the DBCONV program from Cognos Controller Configuration.
You enter the values for Database Connection and click Test – Connection Succeeded.
Then you click on the arrow to start DBCONV module, and click on CONNECT button to connect to the oracle database. Here you get above error.
If you get below error, it is because you have not entered domain.com value in the name in Cognos Configuration or in the TNSNAMES.ORA file.
** ERROR: java.sql.SQLException: IO Error: Unknown host specified
Only enter PT0572 in Cognos Controller data source will give that error.
Solution:
Inside Cognos Controller Configuration for the FAP database you must enter an EZCONNECT data source name. Like this;
oracleaixservername.domain.COM:1521/PT0572.domain.com
The important is that it is oracle host name (colon) port number (slash) tnsnames alias including domain.com
The TNSNAMES.ORA file should contain this;
PT0572.DOMAIN.COM=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=oracleaixservername.DOMAIN.COM)(PORT=1521))
(CONNECT_DATA=
(SID=PT0572)
)
)

And Cognos Controller Configuration should be like this:
Database type: Oracle
Name: FAP
Provider: ORAOLEDB.ORACLE.1
User ID: CCR_FAP_data_mart (the oracle schema name)
Password: *******
Data Source: oracleaixservername.domain.com:1521/PT0572.domain.com

You must exit Cognos Controller Configuration program between every change to the TNSNAMES.ORA file. The file is only read during start of the Controller Configuration program (ControllerConf.exe *32).

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg21635338

Product:
Cognos Controller FAP 10.1.1
Microsoft Windows 2008 R2 server
Cognos BI 10.1.1

Symptom:
Error to start Cognos BI service.
No error in Cogserver.log file, you find any errors in file catalina.2014-03-27.log

Cause:
When publish in FAP you get error C8ITKShared (not found in java.library.path) after you have changed TM1 from native security to use CAM (Cognos BI) security on the FAP cube.
You added the folder to TM1 Bin folder to PATH, c:\program files\ibm\cognos\tm1_64\bin
This disturbs Cognos Bi, and it will not start the service.

Solution:
Remove the folder to tm1 bin from the Windows PATH environment variable.

Copy two files from folder c:\program files\ibm\cognos\tm1_64\bin to the folder c:\program files(x86)\ibm\cognos\c10\server\fap folder.

C8ITKproxy.dll
C8ITKshared.dll

Restart the Cognos FAP service.
Test to do an Initial Publish in FAP again.

http://www-01.ibm.com/support/docview.wss?uid=swg21450399

Product:

Cognos Controller 10.1

Windows 7

Symptom:

How do I uninstall Cognos controller client from my computer ?

So I can install a new version of Cognos controller client.

Solution:

Log on the computer

Go to control panel

Go to program and features

Find Cognos Controller Client in list

Click to uninstall the program

Remove this folders (if they exist).

c:\program files (x86)\cognos\ccr\

%appdata%\cognos\ccr

%localappdata%\VirtualStore\Program Files (x86)\cognos\ccr\

Reboot client computer

Turn off the UAC (user access controller) in control panel

Install the Cognos Controller client from the dos-prompt,

Select CMD from start menu, and right click and select “Run As Administrator”

Change to the folder where you have copied the MSI file locally.

Then enter this to start the installation

msiexec /i CCRLocalClient.msi

Answer the questions with the appropriate server name.

http://servername.domain.com/ibmcognos/controllerserver

Do not select a cache folder.

Unzip the Integration.zip and jre.zip files in the C:\Program Files\cognos\ccr directory.

 

More information on how to install Cognos Controller

http://www-01.ibm.com/support/docview.wss?uid=swg21608353

http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ctrl_inst.10.1.0.doc%2Fctrl_inst_id4389remote_Excel_add-in_single.html

More information on what type of Cognos controller clients there are

http://www-01.ibm.com/support/docview.wss?uid=swg21371088

Product:

Cognos Contoller 10.1.1

Windows 2008 R2 Server

Oracle 11g

Symptom:

New installation of Cognos controller 10, to be used with Oracle database.

When click connect in Cognos Controller DBCONV program you get a error message.

Error message:

** ERROR: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 50

** ERROR: java.sql.SQLRecoverableException: IO-Fel: could not resolve the connect identifier

 

Solution:

Change the tnsnames.ora file for the oracle client on the Cognos Controller server.

Ensure the tnsnames.ora file only contain the values for the cognos controller database, not reference to other oracle schema or databases.

Ensure the information is written in several lines, as shown below, and not in a single line in the tnsnames.ora file.

FRANGO=  (DESCRIPTION=    (ADDRESS=(PROTOCOL=TCP)(HOST= SERVERNAME.DOMAIN.COM)(PORT=1521) )   (CONNECT_DATA= (SERVICE_NAME=service_name)))

Replace italic above with the schema/oracle server name.

 

More information

http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ctrl_inst.10.1.0.doc%2Fctrl_inst_id311UpdatedinstallationinstructionsforCreateanIBMCogno.html

http://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm

Product:

Cognos Controller 10.1.1

Windows 2008 R2 Server

Oracle database

Symptom:

New installation of Cognos Controller 10.1.1. When user select maintain – jobs – define menu, they get a error message after some time.

Problem message:

Could not create the view: !Could not create controller of type com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionViewController for composite class com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionUI!

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:516)

at com.ibm.cognos.ccr.core.ui.databinding.widgets.AbstractControllableComposite.createController(AbstractControllableComposite.java:67)

at com.ibm.cognos.ccr.core.ui.databinding.widgets.AbstractControllableComposite.getController(AbstractControllableComposite.java:58)

at com.ibm.cognos.ccr.core.ui.view.AbstractViewPart.initializeController(AbstractViewPart.java:547)

at com.ibm.cognos.ccr.core.ui.view.AbstractViewPart.initializeController(AbstractViewPart.java:490)

at com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionView.createPartControl(JobDialogDefinitionView.java:55)

at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:375)

at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:229)

at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)

at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:313)

at org.eclipse.ui.internal.ViewPane.setVisible(ViewPane.java:534)

at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)

at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)

at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)

at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:473)

at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1245)

at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1198)

at org.eclipse.ui.internal.PartStack.showPart(PartStack.java:1597)

at org.eclipse.ui.internal.PartStack.createControl(PartStack.java:643)

at org.eclipse.ui.internal.PartStack.createControl(PartStack.java:570)

at org.eclipse.ui.internal.PartSashContainer.createControl(PartSashContainer.java:568)

at org.eclipse.ui.internal.PerspectiveHelper.activate(PerspectiveHelper.java:272)

at org.eclipse.ui.internal.Perspective.onActivate(Perspective.java:981)

at org.eclipse.ui.internal.WorkbenchPage.onActivate(WorkbenchPage.java:2714)

at org.eclipse.ui.internal.WorkbenchWindow$27.run(WorkbenchWindow.java:3023)

at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

at org.eclipse.ui.internal.WorkbenchWindow.setActivePage(WorkbenchWindow.java:3004)

at org.eclipse.ui.internal.WorkbenchWindow.busyOpenPage(WorkbenchWindow.java:799)

at org.eclipse.ui.internal.Workbench$23.runWithException(Workbench.java:1224)

at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)

at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:180)

at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:150)

at org.eclipse.swt.widgets.Display.syncExec(Display.java:4683)

at org.eclipse.ui.internal.StartupThreading.runWithWorkbenchExceptions(StartupThreading.java:50)

at org.eclipse.ui.internal.Workbench.busyOpenWorkbenchWindow(Workbench.java:1220)

at org.eclipse.ui.internal.Workbench.access$31(Workbench.java:1196)

at org.eclipse.ui.internal.Workbench$58.run(Workbench.java:2215)

at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

at org.eclipse.ui.internal.Workbench.openWorkbenchWindow(Workbench.java:2212)

at com.ibm.cognos.ccr.core.ui.util.WorkbenchUtil.openPerspective(WorkbenchUtil.java:685)

at com.ibm.cognos.ccr.integration.application.internal.IntegrationServiceImpl$MyPerspectiveOpener.openNewPerspective(IntegrationServiceImpl.java:136)

at com.ibm.cognos.ccr.integration.application.internal.IntegrationServiceImpl$MyPerspectiveOpener.run(IntegrationServiceImpl.java:112)

at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)

at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)

at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4140)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)

at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)

at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)

at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(IntegrationApplication.java:85)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:144)

at java.lang.Thread.run(Thread.java:736)

Caused by: com.ibm.cognos.ccr.common.InvalidContextException: !Could not load model: job!

at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.getModel(AbstractLifeCycleManager.java:235)

at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.<init>(AbstractLifeCycleManager.java:100)

at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.<init>(AbstractLifeCycleManager.java:89)

at com.ibm.cognos.ccr.integration.application.ValidatingLifeCycleManager.<init>(ValidatingLifeCycleManager.java:47)

at com.ibm.cognos.ccr.integration.application.views.AbstractDialogController.<init>(AbstractDialogController.java:91)

at com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionViewController.<init>(JobDialogDefinitionViewController.java:39)

… 63 more

Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: !Unable to find instance of model of type: job[JobModel]!

at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(DefaultModelContext.java:422)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:396)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(DefaultModelContext.java:255)

at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.getModel(AbstractLifeCycleManager.java:233)

… 68 more

Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVICE, argument(s)=[FAIL:!Array index out of range: 50!, http://servername/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, ?]

at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(JAXWSClient.java:107)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(RemoteDao.java:91)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.getLatestSequenceNumber(RemoteDao.java:63)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.getLatestSequenceNumber(CachingDao.java:78)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.isUpToDate(CachingDao.java:175)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(CachingDao.java:90)

at com.ibm.cognos.ccr.common.AbstractModel.load(AbstractModel.java:572)

at com.ibm.cognos.ccr.common.AbstractModel.load(AbstractModel.java:562)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(AbstractModelFactory.java:74)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(AbstractModelFactory.java:66)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:394)

… 70 more

Caused by: java.lang.RuntimeException: MTsxMDE6MjM4ZmZkZWUtZDdhMC1hZTc5LTI1MDQtMjEyYjQ5MTJjNzQwOjMzNDkxMjM0OTQ7MDszOzA7

at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(WebServiceConnectionException.java:65)

at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(WebServiceConnectionException.java:52)

… 81 more

 

Cause:

The tnsnames.ora file is to large for Cognos Controller to use.

Solution:

Create a smaller tnsnames.ora file and place in a separate folder on the controller server, for example d:\oracle.

Make the tnsnames.ora file only contain the information for the Cognos Controller database, and no other oracle database or oracle schemas.

 

Then update the ccr-system-properties.properties file, often located in folder, c:\Program Files (x86)\Cognos\C8\Server\integration.

 

# IBM SOURCE CODE HEADER START

# =====================================================================

# OCO Source Materials

#

# BI and PM: ccr

#

# (C) Copyright IBM Corp. 2004, 2009. All Rights Reserved

#

# The source code for this program is not published or

# otherwise divested of its trade secrets, irrespective of

# what has been deposited with the U.S. Copyright Office.

# =====================================================================

# IBM SOURCE CODE HEADER END

# User defined System properties

# Oracle Network admin directory path, the location of the TNSNAMES.ORA file

oracle.net.tns_admin=D:\\oracle

You must reboot the Controller server to make changes to file ccr-system-properties.properties take affect.

More Information:

http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ctrl_inst.10.1.0.doc%2Fctrl_inst_id311UpdatedinstallationinstructionsforCreateanIBMCogno.html

Product:

Cognos Controller 10.1.1

Microsoft Windows 2008 R2 server

Citrix server

Symptom:

Cognos Controller client program is slow to start. The citrix server that run the Cognos Controller client have no access to internet. When checking the Internet Explorer settings for  “Check for publisher’s certificate revocation” it is marked. Removing the mark, makes the program start faster.

 

Solution:

You can force the setting in Internet explorer for the user by create a power shell script, and then make it run before the users starts the cognos controller client on the citrix server.

Below a example of a script to update the registry:

# Change registry key to uncheck IE security setting: “Check for publisher’s certificate revocation”

Push-Location

  Set-Location “HKCU:\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust        Providers\Software Publishing”

Set-ItemProperty . State “dword:00023e00”

Pop-Location

 

More information:

http://www-01.ibm.com/support/docview.wss?uid=swg21441779

Product:

Cognos Controller 10.1.1

Microsoft Excel 2007

Windows 2008 R2 Server

Citrix server

Symptom:

When user run a standard report in Cognos Controller, and select to view the report in Microsoft Excel 2007 ( or Excel 2010) they get a dialog, telling the file content is wrong.

Error message:

“The file you are trying to open, [File_name.xls] is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?”  (Yes | No | Help)

 

Solution:

Excel 2007 introduced the concept of Extension Hardening.  Extension Hardening does checks ahead of time to ensure that the file content matches the extension and, if applicable, the MIME type. The upside of Extension Hardening is that it blocks one vector for malformed Excel content attacks, like Trojans. The downside is that it also breaks the classic ASP method of Excel reporting, and the opening of Cognos Controller reports in Excel.

 

There is no granularity in the setting. Extension Hardening cannot be turned off for some websites or content sources, and on for others. It can only be disabled, enabled with a prompt, or enabled with blocking. Extension Hardening can be controlled during installation by the Office Deployment files, or afterwards by group policy or editing the registry.

 

Registry:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]

“ExtensionHardening”=dword:00000000

Possible value settings: Allow different (dword:00000000); Allow different, but warn (dword:00000001); Always match file type (dword:00000002). If the

ExtensionHardening value is not present, Excel defaults to Allow different, but warn.

 

Create a powershell script that is run before the Cognos Controller client program on the citrix server, to set the value off.

This is a example of the script:

Push-Location

If (!(Test-Path “HKCU:\Software\Microsoft\Office\12.0\Excel\Security”))

{

New-Item “HKCU:\Software\Microsoft\Office\12.0\Excel\Security” -force

}

Set-ItemProperty “HKCU:\Software\Microsoft\Office\12.0\Excel\Security” -Name  ExtensionHardening -Value “0” -Type DWORD -force

Pop-Location

 

More information:

http://www.jwgoerlich.us/blogengine/post/2009/08/11/Excel-Extension-Hardening-and-Web-Applications.aspx

Product:
Cognos Controller 10.1
Windows 2008 Server

Problem:
How do I list all the members that are part of a Microsoft Active Directory group ?

Solution:
Log on to a Microsoft Windows 2008 server in the domain.
Start a CMD prompt
Create a temp folder
Go to the temp folder
Enter following command to get a list of users in a AD group:

dsquery group -domain EU -samid citrix_app_cognoscontroller | dsget group -members > cognoscontrollerusers.txt

Replace above EU with your domain name
Replace above citrix_app_cognoscontroller with the AD group you want to list
Replace above cognoscontrollerusers.txt with the name of the text file you want created.

The file is crated in the temp folder, you are standing inside.

To find out if a group exist in your domain you can enter:
dsquery group -samid citrix_app_cognoscontroller

If the group exist in the domain you are, it will print the CN string in AD for that group.

To find out what groups a user are member of you can enter:
dsquery user -samid roger | dsget user -memberof -expand

This will list all Active Domain groups the user “roger” is part of.
Replace above roger with the username you want to check.

Product:
Cognos Controller 10
Windows 2008 R2 server

Problem:
How do i add a new user to a local group on the server from the command line ?

Cause:
Can be needed in testing purpose on a new installation of Cognos software, to see if the issue is because of the windows profiles temp files. Test with a new user can be good.

Solution:
Start CMD as administrator on the Server ( or client computer).

Enter ; to create user mike
NET USER /ADD MIKE

Enter ; to set his password to password
NET USER MIKE PASSWORD

Enter ; to add mike to the local administrator group
NET LOCALGROUP ADMINISTRATORS MIKE /ADD

Enter ; to list users in the local group
NET LOCALGROUP ADMINISTRATORS

Enter ; to start a remote desktop session
MSTSC /v:127.0.0.1 /w:1024 /h:768

/v enter the name of the server or IP
/w set the width of the window
/h set the height of the window

More Information:
http://ss64.com/nt/net_useradmin.html
http://ss64.com/nt/mstsc.html