XTIVIA BLOG
Unused Web Content Portlet
Introduction The Unused Web Content portlet is a control panel portlet. This portlet allows site administrators to see web content that is not used in any web content display portlet. The site administrator can take action on each piece of web content by either previewing it or...
Concerned about the integrity of your Liferay Documents and Media database? Check out the XTIVIA Database Checker Plugin
Introduction The Documents and Media File System Checker portlet was developed by XTIVIA, the 2012, 2013 and 2014 Liferay North America Partner of the Year. As we work with Liferay customers, we often run into situations where the client has a Liferay environment (from...
Get Mobile!
If you have reached this blog post, I guess it is because either you are bored (there are better things to do when you are bored, by the way...), you are interested on how to develop mobile apps (ok, I'll try to help!) or you are asking yourself if your business needs a mobile...
Overriding a JSP Without Modifying the Original
Adding A New button Recently I wanted to add my own button into the list of web content in the Liferay control panel. There were already a couple buttons there that enable and disable when one or more web content items are selected. My plan was to just copy whatever...
How to Fix ORA-00257: archiver error. Connect internal only, until freed
Click to download full Oracle Error eBook A very common Oracle database error that is basically telling you that you have run out of logical or physical space on the mount, disk, or your db_recovery_file_dest location that holds your archivelogs. When you get this error your...
MySQL Cascading Configuration Files
MySQL creates a default configuration file named my.cnf (or my.ini in Windows), that can be edited to include and fine tune the startup options to meet the needs of your environment. This is often more convenient than entering these values every time you start the service. You...
SQL Server – List Database Roles and Associated Users – SQL Toolbox
The sys.database_role_members view contains two columns one for the role id and one for the member id creating a relationship between the role and the user. When we join this data to the sys.database_principals view we can retrieve the friendly name of the role and using...
ORA-01555 Snapshot Too Old
ORA-01555 Snapshot Too Old The snapshot too old error is a very common error we get asked about on a regular basis. It’s also a pretty simple error to avoid if you know what to look for and how to configure your queries and the Oracle database. The error is basically stating...
Using SQL in DB2 to Write REORG Statements
DB2's automated maintenance does not currently allow us to automate inplace reorgs. Inplace reorgs are more online than other reorgs, and in my experience are heavily used. This means that many DBAs wrap some sort of scripting around reorgs. Working in a variety of client...
ORA-00936: missing expression
This error comes up pretty often and can be caused by a lot of different things. Usually, this is a pretty easy one to solve. It's mostly just a syntax error and you forgot part of your SQL statement. You need a select, a column, from clause, and optionally a where clause to...