Loading...
How to create Read Only user in Oracle WebLogic Server

1. Log in to WebLogic console as Admin user(User ‘WebLogic’); the URL looks like http://localhost:7001/console

2. Click on the Security Realms > My Realms

3. Create a user by clicking the NEW button (Or click on the existing user and go to Step 5 )

4. Fill the fields for the new user

5. Click on the user

6. Click on the Groups tab, Move the group MONITOR from left to right. Click Save. Not login to WebLogic console as this user. He can’t edit anything in the WebLogic console but read all the configurations

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
How to disable Primavera P6 admin config or Application Settings from User

Primavera P6 admin config is one of the powerful area which allows the user to change the P6 database setting, Authentication, Configuring LDAP, BPM & BI Integration Settings, Configuring P6 Web Service & P6 API, Daylight setting and much more. A change in the P6 admin config affects the whole application. Suppose, if a user updates the database URL incorrectly then P6 won’t work. So, granting this right to every-one contains Risk. Only System Administrator and P6 Admin superuser could have access to this setting. Typically, the P6 admin config looks like below. /p6/action/admin is the config path to access the admin config

Primavera P6 ships with a Global security Profile called ‘Admin SuperUser’. This user has all the powers to modify the P6 including admin-config. We can’t modify this user profile, either grant this profile to the System administrator and P6 Administrator

Disable P6 Admin Config

As I mentioned earlier, we don’t have option to the profile Admin Superuser. We need to create a Global Security Profile, so we can disable the admin config. To do this:

1. Login to P6 as the admin user, Go to User Administration, Click on Global Security Profile, Select/create a profile, Uncheck the Edit Application Settings under Administrator. This will stop user to see the admin config

The User Administration is under link Administration (top right corner) on version less than and equal to 16.2

2. Assign this profile to a user who you don’t want to access P6 Admin config

3. First, the above-granted user can’t edit Application Settings under Administration

4. If the user tries to access the P6 admin config (/p6/action/admin) then he will be redirected to a Login screen for credential who has authorized to access admin config and an error message User does not have permission to modify P6 configuration will be displayed like below

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
How to increase the session timeout in Primavera P6 EPPM

The session timeout Is the maximum amount of time the user session is active regardless of interaction. In this section, I have explained how to check the default Primavera p6 session timeout and how to increase or decrease the session timeout.

1) What is the default session timeout in Primavera P6

1.1) If you deployed Primavera P6 in WebLogic server then identifying the default session timeout is an easy task. First, you need to login to P6 as an application user, then login to WebLogic server > Deployment > Expand P6.ear > Select P6.war

1.2) Click on the Monitoring > Session tab. You will see the session timeout in Max Inactive Interval as 3600 seconds, so the default Primavera P6 session timeout is 1 hour

2) How to increase of decrease the Primavera P6 Session Timeout

Here we are going to increase the P6 session timeout to 2 hours

2.1) Open a command prompt > Go to the P6Home\P6 directory > Backup the P6.ear file > Issue the following command to unzip the p6.war file from the p6.ear file

jar xf p6.ear p6.war

2.2) Issue the following command to unzip the web.xml file from the p6.war file

jar xf p6.war WEB-INF\web.xml

2.3) Edit the web.xml file in a notepad file > Search for session-timeout > Increase the time to your desired value. I increased it to 120 minutes, 2 hours

2.4) Update the web.xml file back to the p6.war file

jar uf p6.war WEB-INF\web.xml

2.5) Update the p6.war file back to the p6.ear file

Jar uf p6.ear p6.war

2.6) Redeploy the modified p6.ear file into the WebLogic server > Login to P6 to create a session > Check the WebLogic server for the timeout as mentioned in 1.2

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
About Primavera P6 Jobs, P6 Job Server and P6 Services.jar

In Primavera P6, many of the functionality requires time to complete, say more than 8 seconds. Oracle Primavera predefined these types of long-running functionality as a job which runs in the background. For example, copy and paste Projects. The time required to copy, and paste projects is depending on the number of projects, project size etc., so performing this task as a background job is an efficient method so the user doesn’t need to wait till the paste operation completes. Below I have mentioned some of the Primavera jobs 

  1. Schedule a project(‘s)
  2. Summarize a project or EPS
  3. Apply Actuals
  4. Export an XER file
  5. Import a Project from XML
  6. Export a Project to an XML
  7. Initiation Synchronization
  8. Copy Project
  9. Generate PM Report
  10. Store Period Performance
  11. Create Baseline for a Project
  12. Publish Project
  13. Send to Unifier
An example scenario how the P6 job works

Below I have explained an example scenario about how a Job created, processed and finished by Primavera P6

1. User Copy a Project in Primavera P6

2. A record inserted into the JOBSVC table with JOBTYPE = CopyProject and STATUS_CODE = PENDING

3. The job server in P6 web picks the record and start processing and update the STATUS_CODE = RUNNING

4. Meantime, user can perform other activities in P6 and see the status of the Job in VIEW SERVICE STATUS page 

5. The P6 Job Server in P6web updates the STATUS_CODE = COMPLETED/FAILED status once it done. The same status can be shown in the view service status. 

Where is the P6 Job Server available?

The P6 Job Server is available in all the below Job modules

1. P6.ear (P6 Web Application)

2. Primavera Integration.Ear (P6 Integration API Server)

3. intgserver.ear (P6 Integration API )

4. P6services.jar (P6 Job Server)

5. p6ws.ear (Primavera Web Services)

P6 Job Server Configuration

The primavera admin config lists all the P6 job services. We can see and tune each p6 jobs by opening  the P6 admin config > Expand the Configuration used by the p6 modules > Expand services >>Expand each job service and configure the setting

Here, I have expanded the Scheduler job and I can tune as below 

Interval => P6 scheduler wait for 10s second before running the next job

Concurrent Threads => 2 Java threads run at a time and each thread takes a scheduler record from JOBSVC table and process it. A value of 0 indicates that this service will not run on the server (A thread per Server core, suppose you have 4 cores than don’t crease the concurrent thread value more than 4)

Active Mode => Choose true if you want jobs processed continuously until all jobs finish. Choose false if you want each job processed according to the Interval.

Like the above, we can enable/disable, increase/decrease concurrent threads of the jobs on each application. For example, I could enable SUMMARIZER, LEVELLER& SCHEDULER on one JOB Server with the high concurrent job and disable others jobs. On a large scale P6 environment, it is necessary to have a dedicated JOB server to process these jobs.

For example, assume there are 200 concurrent users using P6. One is summarizing an EPS, and other is publishing an EPS. If the EPS consist of 1000 project then 1000 record for Summarizer, and 1000 for Publisher records created in the JOBSVC table. P6 web only takes care of these 2000 jobs, then it affects the performance and may get a chance of Job will fail. A dedicated P6 job server is highly recommended.

How to create and run a P6 job Server
  • Oracle recommends running the P6 Job Server on a dedicated server. The p6services.jar is a jar file that comes with the P6Home directory as shown below

  • Run the dbconfig and create a separate P6 configuration for P6Services so you can tune the Job configuration. 

  • Make sure the BreBootstrap.xml should point to the new configuration ‘P6 Services’

  • If you open the admin config, you will notice a separate configuration for P6services.jar like below 

  • Now create a batch file called startP6Service.bat or shell startP6Service.sh & append the following line in it. Place the bootstrap.home and p6services.jar path according to your environment 

java -Xms4096m -Xmx4096m -Dprimavera.bootstrap.home=C:\P6EPPM_16_2\p6 -XX:PermSize=128m -XX:MaxPermSize=256m -XX:NewSize=128m -XX:MaxNewSize=256m -XX:SurvivorRatio=8 -jar C:\P6EPPM_16_2\p6\p6services.jar

  • You can manually invoke the P6 Job server by double click on the batch file.  You will see the P6 Services Started Sucessfull message as shown below. This will read all the PENDING jobs in the JOBSVC table based on the JOb setting in admin config  

  • You can put this batch file in Windows Job Scheduler or Linux CRON job as a nightly job so the Job service will run every night at less loading time.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Is it possible to Logout Primavera P6 Web through SQL Query?

Recently I noticed a question in Oracle community forum that sounds interesting to me. The question is ‘How to Log out a Primavera P6 EPPM user through SQL Query‘. I have not faced this type of scenario before, so I checked in to my local p6 weather is it possible.

I know the Primavera P6 inserts records into USESSION table when a user logs into Primavera P6 EPPM. Will it delete the USESSION table after the user Logs out? Yes, P6 deletes the record but not immediately when the user logs out. Instead, the P6 background job deletes the records on a scheduled interval.

The question here is Will deleting the user records in the USESSION table Log-out the user from Primavera P6? I initially thought so but went and tried. The answer is NO. We can not log out the user from P6 by deleting records from USESSION table. I am doing the following three steps to illustrate further

1. User Login to Primavera P6 EPPM

2. Deletes the USESSION table for the corresponding user

3. Refresh the P6 page to see the user is logged out

Let’s begin each points: 

1. User Login to Primavera P6 EPPM

Here, I logged into P6 as ADMIN user account 

  2. Deletes the USESSION table for the corresponding User

Here, I deleted the session for user ADMIN once he logged in. The Query is below: 

delete from usession where user_id = (select user_id from users where user_name = ‘admin’)

  3. Refresh the Primavera P6 

Here, I refresh the page and navigate to another tabs in P6 to check the user is signed out. Actually, the session is still valid

I checked the USESSION table again. P6 created a new session in the USESSION table for the user ADMIN. I have waited for 15 minutes and refreshed P6. It renders well.  

I did the same above 3 steps in Primavera Professional for EPPM, that is Login to Professional, Deletes the USESSION table, Refresh the page. I received the following error message, so Deleting USESSION table logs out the P6 Professional. Thanks, Ravi &  Nilesh for your valuable comment in LinkediIn. 

Conclusion

I guess Primavera P6 Web kills the Session through Java when the user Logs out from P6 (JAVA & JSESSIONID). And this is my knowledge about P6 and not from the Oracle documentation.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
How to Create Primavera P6 EPPM Database Schemas in Microsoft SQL Server

In this section, I have explained how to create a Primavera P6 EPPM Database Schemas in Microsoft SQL Server.

Follow the links If you are interested in Microsoft SQL Server Installation

Microsoft SQL Server 2017 Developer Edition Installation

Microsoft SQL Server Management Studio 2017 Installation

Open Microsoft SQL server Ports in Firewall

Creating Primavera P6 EPPM schemas in MS SQL Server

Follow the instruction to Create p6 EPPM schemas. Assume you have downloaded the Primavera P6 software or installed the Primavera P6 Home in your computer

1. Go to your P6_Home\database folder and double click on the database.bat file

2. The Primavera database setup wizard will open on the screen like below

3. Input the MS SQL Server database details (The user SA is the admin super account in MS SQL Server Database. Please refer the Step 15 of MS SQL Server DB Installation)

4. Input database keystore if any or skip the details and click Next

5. Click Next

6. Input the PUBUSER, PRIVUSER AND PXRPTUSER password

7. Input Primavera P6 application administration username and password, Load/Unload the sample P6 database and select the currency for the database

8. Click Next once all are successful

9. Click Finish Once Done

10. Open the Microsoft SQL Server Management Studio >> Click Connect >> Input SA connection details >> Click Connect

11. You will notice the database PMDB under the database & PUBUSER, PRIVUSER, PXRTPTUSER under Security > Logins as like below

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Configure Windows Firewall for Microsoft SQL Server 2017 – Part 4

This is the continuation if Microsoft SQL Server installation series. In this section, we walk through how to allow Windows Firewall to work with Microsoft SQL Server. Follow the links if you are interested in Microsoft SQL Server Installation

Microsoft SQL Server Installation

Create a Database in Microsoft SQL Server

Installation of Microsoft SQL Server Management Studio

Allow Firewall to connect to MS SQL Server

Follow the points to allow outside application to connect to Microsoft SQL Server through Windows Firewall

1. Type in Firewall and select Windows Firewall and Select Advanced Security a shown below

2. Add inbound Rule to allow the MS SQL Port in Windows Firewall (Change the port if it is a custom port)

3. Open Windows Start Menu > Go to Index under M >> Select SQL Server Configuration Manager

4. Expand SQL Server Network Configuration > Select the Protocols for <DATABASE_NAME > Double click on the TCP/IP > Select the Protocol Tab > set the property Enable = Yes

5. Now click on the IP Address tab > Set the Enabled = Yes, Dynamic Port= blank for all the protocols and Click Ok

6. Open Windows Services >> Restart Microsoft SQL Servers || Restart the Machine. That’s it. Try an external application to connect to Microsoft SQL Server.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

8 total views, 0 views today

How to install Microsoft SQL Server Management Studio 2017 – Part 3

In this section I have explained to install Microsoft SQL Server Management Studio 2017. Follow the two links If you are looking to install SQL Server or Creating Database

How to Install Microsoft SQL Server 2017 

How to Create a Database in Microsoft SQL Server 2017 

Microsoft SQL Server Management Studio 2017 Installation 

Go to the Microsoft SQL Server Management Studio Download Link and Download SQL Server Management Studio


2. Double click on the downloaded file

3. The Microsoft SQL Server Management Studio wizard will open on the screen. Click on the Install button

4. The installation will progress on the wizard

5. Click Close on the wizard once the installation complete

6. Go to Windows Start Menu >> Click on the Microsoft SQL Server Management Studio under Microsoft SQL Server Tools

7. Click on the Connect >> Select the Database Engine

8. Input the connection string and Click Connect

Server Name = The SQL Server Host Name

Authentication = Windows or SQL Server authentication ( For SQL Server credential, Refer Step 15 in SQL Server Installation )

9. The SQL Server Management Studio will display like below once it got connected . As you see below, we could see the database ‘MSSQLSERVER’ we created in the previous post

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

13 total views, 0 views today

How to create a database in Microsoft SQL Server 2017 Developer Edition – Part 2

This is the continuation of my previous post ‘MS SQL Server 2017. This section we explained how to create a database in MS SQL Server.

Create a Database in MS SQL Server

1. Go to Windows Start Menu >> Under M >> Select SQL Server 2017 Master Data Services Configuration Manager

2. The Master Data Services Configuration Manager opens on the screen. Click on the Database Configuration >> and Select Create Database

2. The Create Database wizard appears on the screen >> Click Next on the screen

3. Input the hostname >> Choose the Authentication Type >> Input the credentials if you selected SQL Server Account like me >> Test the connection

Note: I specified the password in MS SQL Server installation. Please refer the Step 15 of MS SQL Server Installation for SA password reference

4. Input a database name and select Next


5. Input the Windows user account which you grant Administrator access to this database >> Click Next


6. Click Next


7. Once the database successfully created >> Click Finish


8. You will see the MS SQL Server instance like below .


9. You will see the list of MS SQL Server instance running in the Windows Services

That’s it. The below steps are optional. They are required only you want to enable MDS on MS SQL Server

Configuring Master Data Services Server Configuration in MS SQL Server

9. Click on your Host name (Here: Gayathri-HP) and verify all the IIS components are installed. For me, some of the IIS components are missed as like below , so I going install those in the next steps


Open the Turn Window Features On or Off


Toggle On the following IIS components required for the Microsoft SQL Server and Click Ok



Restart the machine and check again. You will see the Master Data Services Server Configuration like below


10. Click on the Web Configuration >> Select the Website from IIS Server >> Click create >> Input an Alias Name >> Input the Window Credentials >> Click Ok

11. You will notice the alias as the arrow mentioned >> Now click on the button Select under Associate Application with
Database << Input the server details >> Click Connect >> Click Ok

12. You will notice the selected instance as the arrow mark mentioned >> Click on the Apply button

13. Open File Explorer and Copy the following packages from Samples to Configuration directory as shown below

10. Open a command prompt as administrator and run the following commands

Cd C:\Program Files\Microsoft SQL Server\140\Master Data Services\Configuration

MDSModelDeploy deploynew -package chartofaccounts_en.pkg -model ChartofAccounts -service MDS1

MDSModelDeploy deploynew -package customer_en.pkg -model Customer -service MDS1

MDSModelDeploy deploynew -package product_en.pkg -model Product -service MDS1

11. Launch the IIS MDS web by going to the http://gayathri-hp/MDS1/home/gettingstarted

That’s it. In my next post, I will explain how to install MS SQL Service studio so that we can access the SQL Server instance and query against it.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

17 total views, 0 views today

Step by step instruction to install Microsoft SQL Server 2017 Developer Edition on Windows 10 – Part 1

In this post, I have explained a step by step instruction to install Microsoft SQL Server 2017 developer edition on Windows 10 with screenshots.

Note: I uninstalled the Microsoft Visual C++ 2017 Redistributable (x86) and (x64) on my machine before proceeding with this installation, I installed it again after the SQL Server is installed.

Download Microsoft SQL Server 2017 Developer Edition

1. Go to the Microsoft SQL Server Download website & Download the developer edition as shown below

2. Open the Downloaded file. A wizard will appear like below. Select the option you want. I chose Download MS SQL server installation Media, so I can use the software later

3. Choose the location where you want to download the Microsoft SQL Server

4. The wizard begin to download the Microsoft SQL SERVER

5. Close the wizard once the download is completed. The MS SQL Server software’s will be residing in the location mentioned in step 3

Microsoft SQL Server 2017 Installation

6. Go to the SQL SERVER software folder location and double click on the SQLSERVER2017-DEV-x64-ENU.exe. This will extract the software files and open the MS SQL Server setup wizard

7. Click on the installation on the left-hand side and click on the New SQL Server stand-alone installation or add features to an existing installation

8. Choose the Developer and click Next

9. Select as shown below and click Next

10. Ignore the firewall warning now. We will configure it later

11. I selected all. Select the ones to need for you

12. Choose the option you want and click Next

13. Select as shown below & Click Next

14. Click Next

15. Click on the Server Configuration tab. Here I chose Mixed Mode, so
the SQL Server SA user and windows login user are administrators to MS SQL Server.

Note: By clicking Add Current User will add the logged in Windows user account to SQL Server administrator. You can add a different user as well by click on the button Add

16. This is optional. Click on the FILESTREAM tab and enable as shown below to Enable FILESTREAM in MS SQL SERVER

17. Add the user you want as Administrator and click Next

18. Click Next

19. Click Next

20. Add your user account and click Next

21. Click Next

22. Click Accept and Next

23. Click Accept and Next

24. Click on the button Install

25. The installation progress will begin, and it takes some time to complete

26. Sometimes the wizard downloads the required files automatically and sometimes it not. If you see the screen like below, then click on each link and download the files; Place those files in a folder; Input the folder in the install path and click Next 

27. Click Close once all completed successfully. You will see a complete message on the title bar, scroll down and check all are successful and check the details bar for the successful status.

If anything failed in this wizard then fix those errors and re-run the installation wizard by running the setup.exe in the software folder and click new install again as like in Step 7

28. You Will find the MS SQL Server in the windows start menu

If you installed Machine Learning then you will see this as well 

In My next post, I will explain how to create a database in Microsoft SQL Server

Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview