Programming Keys is blog for all Programming and technology related articles

Sunday, December 24, 2017

Tata Sky internal error occurred while processing your request kindly restart the application and try again 0xfd9009 fe1001f4

Tata Sky internal error occurred  while processing your request kindly restart the application and try again 0xfd9009 fe1001f4



Steps to Resolve above error:
1. Install the Tata Sky application 2. Launch the TataSky application >error message displayed 3. Launch Task manager and check PCShowServerPMWrapper and NDSPCShowServer services are running >If it is not running close the application 4. Navigate to C:\Users\XXXX\AppData\Local\TATA\TATA Player 5. Select PCShowServerPMWrapper.exe >right Click on PCShowServerPMWrapper and send to desktop 6. Select NDSPCShowServer.exe service >right Click on NDSPCShowServer and send to desktop 7. Select PCShowServerPMWrapper.exe created on desktop>right click and run as administrator 8. Select NDSPCShowServer.exe created on desktop>right click and run as administrator >Minimize the services window (Don’t close the window) 9. Launch the Tata Sky application



its working.


Share:

Thursday, September 14, 2017

ORA-00001: unique constraint entity framework 6 code first approach

ORA-00001: unique constraint entity framework 6


Solution : - 
The solution is to grant user both: 
'CREATE SEQUENCE' and 
'CREATE TRIGGER' 
permissions and re-create the schema.


Share:

Wednesday, September 13, 2017

ORA-30673: column to be modified is not an identity column oracle 12c

ORA-30673: column to be modified is not an identity column

Answer : - 

Currently orcle 12c does not support modifying an existing column as IDENTITY column 

Solution : - Solution is to add a new column and then drop the existing one

ALTER TABLE Tablename ADD (ColumnName_NEW NUMBER(3) GENERATED ALWAYS AS IDENTITY);
Share:

Custom ASP.NET Session State Management with Redis

Custom ASP.NET Session State Management with Redis 


What is Redis?

 Redis is an open source key value data structure store. keys can be strings, hashes, lists, sets, sorted sets etc. This in memory data store is broadly used in session state storing and caching.

Steps to Implement redis session 

1 – Install MSI PACKAGE On Server (Download link) 

2 – GO TO  C:\Program Files\Redis

3-  Open - redis.windows.conf  and redis.windows-service.conf

4 – Add server ip to Config files(10.100.30.16)

 ex – bind 127.0.0.1 10.100.30.16 ::1

5- Install RedisSessionStateProvider from Nuget Manager(Client Machine) 




6- Web.config (Client Machine) - 

<sessionState mode="Custom" customProvider="MySessionStateStore">
      <providers>
<add name="MySessionStateStore" type="Microsoft.Web.Redis.RedisSessionStateProvider" host="10.100.30.16" port = "6379" accessKey="" ssl="false" />
      </providers>

    </sessionState>

Share:

Friday, September 8, 2017

ORA-00904 invalid identifier entity framework 6 migration oracle 12c

ORA-00904 invalid identifier

this issue is caused because of we have used oracle keyword in column name. check below image

Action is keyword in oracle. this is the reason oracle appends "" double quotes in column name. 

Solution : - 
Just remove the double quotes and rename column name in Capitalize letters.




Share:

ORA-01407: cannot update to NULL EF 6 Oracle 12c Migration

ORA-01407: cannot up date to NULL




1 - Solution :- 
If we pass "" (blank) value in model. ef will throw error. pass "." or blank space ( )
to avoid this error.

2- Solution :- Set Default value to column
Share:

How to Encrypt Web config in asp.net mvc

1.      Create RSA key container (Development machine).
a.       Run CMD as Administrator

2.      Export the RSA key container (Development machine).

3.      Prepare the web.config file for encryption (Development machine).
a.        Add the following code to the web.config file as a child of the <configuration> node
    <providers>
      <add name="Neorithm" type="System.Configuration.RsaProtectedConfigurationProvider,&#xD;&#xA;          System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a,&#xD;&#xA;          processorArchitecture=MSIL"
      keyContainerName="InternetBanking"
      useMachineContainer="true"/>
    </providers>
  </configProtectedData>

4.       Encrypt the web.config file (Development machine).
a.       For connectionStrings
b.       For appSettings

The following steps will be performed on each machine where your web-app will be deployed.
5.      Import the RSA Key container into the machine. (Deployment machine)
Copy the “keys.xml” file to the machine where the app needs to run. Run the following command to import the keys:
To Decrypt Web.Config


To Encrypt –

C:\Windows\Microsoft.NET\Framework\v4.0.30319>aspnet_regiis -pef "appSettings" "E:\Model\EBS" -prov "Neorithm"


Share: