by ·Comments Off on Set default websheet

Product:

Planning Analytics 2.0.x – 2.1.13
TM1 Architect

Issue:

How can i set a WEBSHEET page as default for all people who login to TM1WEB?

Solution:

Create a websheet and publish it as public, under a folder in your applications, from TM1 Perspective or PAFE.

Then go into TM1 Architect as Administrator.

Right click on your TM1 instance/application and select security – clients/groups

In the dialog – click on Settings.

At homepage – click on browse and select the websheet you want to use.

At apply to select All Clients.

Click Apply settings.

Click OK.

Now this page will show for all users when they login to the Application in TM1WEB.

If you change the websheet in any why, you need to repeat above steps, as this setting is lost when you publish a new websheet.

More Information:

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=analysis-publish-workbook-tm1-server-application-folder 

https://www.pantarhei.at/wp-content/uploads/2024/09/IBM-Planning-Analytics-2.1_TM1_Web_User_Guide.pdf

IBM Planning Analytics Tips & Tricks: Custom landing pages for TM1 Web

https://code.cubewise.com/blog/the-revenge-of-tm1-web/

IBM Planning Analytics Tips & Tricks: Application Websheet Folders

 

 

by ·Comments Off on 504 Gateway Timeout

Product:
Cognos Analytics 12.0.3
Microsoft Windows 2022 server

Issue:

When try to login to CA12 direct from EDGE on the server you get a error:

504 Gateway Timeout: remote server did not respond to the proxy

The webserver reported that an error occurred while trying to access the website. Please return to the previous page.

Solution:

Check that you not are using a proxy, that not allow you to surf on the server.

Go to control panel

Go to system

Search for proxy

Select Proxy settings

Check that manual proxy setup is OFF.

Test again in your web browser to access the IBMCOGNOS site.

 

More Information:

https://schoolsit.wcgschools.gov.za/index.php/knowledge-base/86-how-to-manually-change-your-proxy-settings-on-windows-10

https://brightdata.com/blog/how-tos/set-up-a-proxy-in-windows-10

https://en.wikipedia.org/wiki/Proxy_server

 

by ·Comments Off on Cannot connect to database server.

Product:

Microsoft SQL server 2022

Issue:

When on the server try to login with a SQL account in SSMS you get a error:

TITLE: Connect to Server
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -2146893019)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver–2146893019-database-engine-error

The certificate chain was issued by an authority that is not trusted

 

Solution:

Mark Trust Server Certificate and click connect.

 

More Information:

https://support.hcl-software.com/csm?id=kb_article&sysparm_article=KB0109476

https://blog.netnerds.net/2023/03/new-defaults-for-sql-server-connections-encryption-trust-certificate/

https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/

https://help.akana.com/content/current/sp/platform_install/install_db_mssql.htm

How to Use a Query to Check an SSL Certificate in SQL Server