Monday, October 12, 2015

ASP.NET Compillation Error BC31007 - Solution

TToday while I am working on the ASP.NET application, I suddenly encountered with below error while trying to debug the application.

I tried couple of actions:

.    ·         Clean and rebuild solution
·         IDE restart
·         Temporary asp.net files cleanup
·         System restart
·         Modified Identity in App pool


Finally it got resolved by modifying the Identity to “Local System” in Application Pool


Server Error in '/My App’ Application.


Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC31007: Unable to open module file 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\crs\b1234521\35244951\App_global.asax.v8-jml4w.0.vb': System Error &Hc0000005& (Visual Basic internal compiler error)

Source Error:

[No relevant source lines]

Source File: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\crs\b1234521\35244951\App_global.asax.v8-jml4w.0.vb :    Line: 0


Show Detailed Compiler Output:

Thursday, August 13, 2015

Independence? ?

Independence ??
Artharathri swathanthram
Adi kanipinchani arundhathi nakshitram

Cheyuthakaye  sramajeevi neerikshna
Chethulette palakula nerlaksha dhorana

Raajipadani rythula aakali chavulu aarnyarodhana
Prajalu padekkina pattinchukoni prabhutwala palana

Seerulu kosame sisthulu
Raju kosame raajyalu

Kanniru munniruga aakrosinche aadadhani seelam
Kalupumokkalanu peekaka enka neeruposi penche voodhara gunam

Netturuvaggi poradi gelichina swarajyam
Nittuniluvuga cheelchi swaha chestunna rajyalu

Enkekkada mana swathanthram
Antha swaha thanthram
Vandhe matharam annam
matalake edhi mana tharam
Sankam poorinche sattavunna sangika dharamaniki thalavanchi kaadhu kaadhu thaladhinchi brathikestunna sagatu manishi Manassu nundi dhativachhina vudhveganni
Mi manassu tho alochinchi manchini avalambinchi saati manishini gauravistarani aakankshisthu

- Sri
(Srinivas G)

Positive India

Soodheerga bharatha prastanam lo konni
apuroopa tholakulu :

Gaganamandali chandhruni thakaam
Manchu Binduvu saitham jaraneeka kashmiraana kavali kaasam
Saamarsyam ikamtyam mandhe ani niruvupinchukunnam
Pathakalu gelicham pathakanni egarivesam
Vignanam lo Sankethikamuga vijaya gadhalu ga maraam
Aaravy desalu gourivinche aaru gajala samskruthi ni kapadukuntunnam

- Sri

Monday, June 15, 2015

TSQL - Search Column and its Value from ALL tables in database

Hi Guys,

Sometimes we try to find a specific Column Name from all the tables in the database. Below is the query-  
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name like '%Column_Name%'
ORDER BY schema_name, table_name

Of course everyone knows about it, you can google it.
But below is the query to find a  Column Name and its Value  from all the tables in database. Isn’t interesting !!

CREATE PROC SearchColumnAndItsValueFromAllTables 
( 
    @SearchStr nvarchar(100) 
) 
AS 
BEGIN 
 
    CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) 
 
    SET NOCOUNT ON 
 
    DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110) 
    SET  @TableName = '' 
    SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''') 
 
    WHILE @TableName IS NOT NULL 
 
    BEGIN 
        SET @ColumnName = '' 
        SET @TableName =  
        ( 
            SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)) 
            FROM     INFORMATION_SCHEMA.TABLES 
            WHERE         TABLE_TYPE = 'BASE TABLE' 
                AND    QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName 
                AND    OBJECTPROPERTY( 
                        OBJECT_ID( 
                            QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) 
                             ), 'IsMSShipped' 
                               ) =
        ) 
 
        WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL) 
 
        BEGIN 
            SET @ColumnName = 
            ( 
                SELECT MIN(QUOTENAME(COLUMN_NAME)) 
                FROM     INFORMATION_SCHEMA.COLUMNS 
                WHERE         TABLE_SCHEMA    = PARSENAME(@TableName, 2) 
                    AND    TABLE_NAME    = PARSENAME(@TableName, 1) 
                    AND    DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'int', 'decimal') 
                    AND    QUOTENAME(COLUMN_NAME) > @ColumnName 
            ) 
 
            IF @ColumnName IS NOT NULL 
 
            BEGIN 
                INSERT INTO #Results 
                EXEC 
                ( 
                    'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)  
                    FROM ' + @TableName + ' (NOLOCK) ' + 
                    ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2 
                ) 
            END 
        END     
    END 
 
    SELECT ColumnName, ColumnValue FROM #Results 
END


Still this query can be optimized and extended further. But it helps to most of the developers. J

Cheers!!



Friday, May 29, 2015

IE 8 to 11 migration and compatibility issues

Hey Guys,

Hope you guys are struggling a bit to overcome the compatibility issues after migrating from IE 8 to IE 11.

Solution is to modify the code as and where it needs to changes (css/javascript/etc). But we do have alternate solutions to continue with our development work and also for very critical applications for which they shouldn’t impact.

Solution-1: Add application/web site to compatibility list under "Compatibility View Settings" menu item. 

Solution-2: Enable "Enterprise Mode" under Tools menu.

Enterprise Mode, a compatibility mode that runs on Internet Explorer 11 on Windows 8.1 Update and Windows 7 devices, let's websites render using a modified browser configuration that’s designed to emulate Internet Explorer 8, avoiding the common compatibility problems associated with web apps written and tested on older versions of Internet Explorer.
Also we have a tool to add the applications list to work on Enterprise Mode – “Enterprise Mode Site List Manager”

Solution-3: Only for development purpose till we get a proper solution/mitigation plan on the changes to be done.

For versions of Internet Explorer 8 and above, this:
http-equiv="X-UA-Compatible" content="IE=9; IE=8; IE=7" />
Renders IE7 and IE8 as IE7, but IE9 as IE9. It allows for different levels of backwards compatibility. In real life, though, you should only chose one of the options:
 http-equiv="X-UA-Compatible" content="IE=EmulateIE8" />
Adding "chrome=1" will allow the site to render in ChromeFrame for those users who have it, without affecting anyone else.
 http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1" />

Hope it helps. Thank you. 

Tuesday, May 12, 2015

ASP.NET - Login failed for user 'DOMAIN\MACHINENAME$'

To avoid below error,
System.Data.SqlClient.SqlException: Login failed for user 'DOMAIN\MACHINENAME$'.

1. Try to prepare proper SQL connection string as

Initial Catalog=your_db_schema;
Integrated Security=False;
User ID=your_db_login; Password=??????" 
providerName="System.Data.SqlClient"/>

2. Remove Persist Security Info=True;

3. Other resolution:
In SQL Management Studio create an account for "DOMAIN\MACHINENAME" (do not browse for the account name, type it in manually) and then grant this account db_owner access to the SLAD database. After this, reinstall the product.

Thursday, April 2, 2015

TSQL - Each table's rows count in a database

CREATE TABLE #counts
(
    table_name varchar(255),
    row_count int
)

EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC

Monday, January 26, 2015

ClearSQL - Oracle PL/SQL developers


Hi Oracle developers,

Yesterday I was going thru couple of technical sites and came across with automated code review and quality control tool for Oracle PL/SQL – “ClearSQL for Oracle”

Couple of features:
Automated code review
Code Metrics
Coding standards enforcement
Support for PL/SQL of Oracle Forms & Libraries
Etc. For more details click here  

Note: Licensed one, but freeware is also available 

Check it. Good luck.

Thursday, January 8, 2015

My view on Recognizing team member

If you can't recognize your team member(s) on right time, you are not fit for the position as a either lead or manager. Since you interact with your team on a daily basis, you objectively see the work they put into their projects every day, their interaction with other teammates and clients, and the attitude they display along the way.