Getting Message | The project has not been released for publication. The job could not be entered in the list of the asynchronous processes.

I was trying to manually publish the whole project and I got the message

Can we change the User ID for given user in RED DOT

Yes we can for eg if we have some user as userxyz and if we would like to have userpqr .. We can change the same.

How to find the List of Group for given Project

SELECT *

  FROM [IoAdministration].[dbo].[IO_GRP]

where grp0 in (SELECT rel1

  FROM [IoAdministration].[dbo].[IO_REL]

where rel3= projectiD

and rel2 = 'GRP')

How to find all the User for Given Project

SELECT usr2,usr3,usr8

  FROM [IoAdministration].[dbo].[IO_USR]

where usr0 in (SELECT rel1

  FROM [IoAdministration].[dbo].[IO_REL]

where rel3= 'Projectid'

and rel2 = 'USR')

order by usr2

How to find all groups in given RED DOT Server

SELECT *
  FROM [IoAdministration].[dbo].[IO_GRP]

How to Get the list of Language Variant for Given Project in RED DOT

SELECT 8
  FROM

[IO_LGV]

IO_LGV

Language variants

How We Can Find the given List of user Who will get the Publication Notification when a RED DOT project is Published

SELECT  *
  FROM    [IO_EJE]

IO_EJE

E-mail notification for a publishing job

How to get the list of User in Given Projects from Database

SELECT [PSU0]
      ,[PSU2]
      ,[PSU3]
      ,[PSU4]
  FROM [Project Name].[dbo].[IO_PSU]
order by psu2



SELECT usr2,usr3,usr8
  FROM [IoAdministration].[dbo].[IO_USR]
where usr0 in (SELECT rel1
  FROM [IoAdministration].[dbo].[IO_REL]

where rel3= 'Projectid'
and rel2 = 'USR')

order by usr2

How To Get Project Details from Database

SELECT *
  FROM [IoAdministration].[dbo].[IO_PRJ]
where prj0=PROJECTGUID

How to find the guid of the project in reddot

Server Manager > Administer Projects > Projects > [PROJECT_NAME], click the "i" icon in the top right hand corner of the Action menu.

How can we allow the user to Have multiple Session in Open Text RED DOT

Go to  Administer Users and Groups --> Users --> Select User --> Click on Edit User Data-->

Set the value of Max. number of sessions  as desired..

Thanks.

Can we use HTML 5 with RED DOt

Yes we can

It is recommended to use projects with HTML5 code after 10.1 SP2 HF18 (Build 10.1.2.391) because the Telerik/RadEditor text editor now also support HTML5 code and would not strip them out.

Is it possible to create 2 (or even more) language variants of the same language?

 Yes. As the Management Server doesn’t really “know” languages, it’s possible to have English (UK), English (US), English (Wales), or German (Germany), German (Austria), German (Switzerland) and so on. Just assign a unique name and you can have as much identical languages as needed.

Is the number of language variants limited?

 No. For the Management Server a language variant is just a table in the project database that stores the language variant depending content.

How to find the the MAIN language variants in given Projects

Go to  SmartTree > Administer Project Settings > Language Variants 

  We should have --> Europe - English Main language

Can We change the same ?

Yes We can Select any lang variant and click edit Edit Language Variant

and Check the Main language Check BOX..

 IMPORTANT: If you delete the main language, then you’ll not be able to modify the content of language variant independent elements!!! So set another language to be the main language before deleting the one that was formerly the main language.